Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number Mask Format with Tabular Form (Text field)

MisterQAug 24 2012 — edited Aug 24 2012
Hi,

By default number that "starts" with a leading zero with decimals - zero is removed. 0.49 => .49

I'm adding for e.g. the mask "FM990D0999". 0.49 => 0.49

Ok this is fixed.


But if I have an integer without decimal. 1 => 1.0

If I change the mask to FM990D9999 1=> 1.


I would like to have a zero leading when it's 0.49 but also no decimal when it's an integer => 1


Any solution? Seems very basic but I can't find a solution!

APEX 4.0 with 11g


Thanks!
Q
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2012
Added on Aug 24 2012
2 comments
2,085 views