APEX V4.2
I have a number field in which I want to hold real numbers up to 3 decimal places. I want the numbers to appear as follows when the data is retrieved into the field from the database whose column is defined as number(5,3)
0.5
5.0
5.12
5.123
This is simple to do in standard SQL using the following function and format mask
select to_char(SPC_CELL_COUNT,'90D999') as SPC_CELL_COUNT....
but...In APEX when I use the above format I get
0.500
5.000
5.120
5.123
It seems that the Number ITEM Attribute Setting "Format Mask" has not effect whatsoever. Any advice on how to get the numbers appearing as you would expect to?
thanks in advance
PaulP