Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I've few custom fields on Account object, which user will drag on to the Account Layout page by customizing it.
I'd like to control the formatting of these fields on the layout.
For example one of my fields is of numeric(18,0) type, and I'd like it to be displayed without the thousand separator. And for some should add the trailing zeros if needed to show two digits after the decimal point.
How can I do this when I'm not using a VisualForce page?
It is not an elegant solution, but if the fields are read-only, then you can create a formula field that calculates the formatted version of the underlying value (and uses the same label text) and use that.
If the fields are editable I think you are out of luck.
You'd need to change the the field setting to Numeric(15,3) to always display that field to the thousandth-decimal-place.
If you only need two decimal places, try (16,2).
Here's how it works: you get 18 total decimal places for a decimal-type field (in Apex, all Numbers/Currencies are of the decimal type). Whenever you define a decimal-type field, you have to give it two parmeters (x,y) -- the first parameter, x, is how many digits you want show to the left of the decimal point, and the second parameter, y, is the number of digits shown to the right of the decimal point. And remember, you get a total of 18 to play with.
Just to note, in Apex Controllers and Visualforce pages, there's always some way you can process your data into the desired format (in Apex Controllers) or often the formatting can take place in the Visualforce page itself.
