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!

Column format with percent ( % ) sign

592819Oct 6 2008 — edited Feb 25 2009
Is there column formatting for percent ( % ) signs?

One of the fields in the report currently displays a number, e.g. "3.75", but need to add the percent ( % ) sign, e.g. "3.75%".

I found the following:
* To display "$5,234.10", I can use "FML999G999G999G999G990D00", this formats with a dollar ( $ ) sign and two decimal places.
* To display "-5,234.10", I can use "S999G999G999G999G990D00", this formats with the sign ( + ) or ( - ) and two decimal places.

However, I fail to find how to add the percent ( % ) sign...

-Frank
This post has been answered by Dimitri Gielis on Oct 6 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2009
Added on Oct 6 2008
4 comments
5,115 views