If you want to skip to the punchline, scroll down past the next few paragraphs where I take you down a merry rabbit-hole that, as it turns out, was completely unnecessary (but still somewhat educational). I would then simply add the class edit_money to any item in the application and it would automatically apply the formatting for example, if the user types in 12345.6, it changes the value to 12,345.60. In the past I had a global javascript file which I’d load with each application with the following basic functions to auto-format any monetary amount fields as the user tabs out of them, whether they appear in an ordinary form or a tabular form: An interactive grid (this one was a work in progress) with some editable monetary amounts. a $ symbol), these are simply removed silently. Also, if the user has copied in any non-numeric characters (e.g. After an amount is entered or modified, the user expects to see the value formatted correctly straight away so I use javascript to take their entered value, convert it to a number, format it and set its value back in the field.

Home APEX Autoformat Numbers in an Interactive Grid Autoformat Numbers in an Interactive GridĪ lot of the applications I build allow users to enter large numbers of monetary amounts, and the way these numbers are presented can have an impact on how easy it is for them to read and check those numbers.Īll such amounts are formatted for display using a system-wide standard format (in our case, the Australian standard fm999g999g999g990d00), with any amounts less than $0.01 rounded to the nearest cent.

Oracle apex number format percentage