cancel
Showing results for 
Search instead for 
Did you mean: 

Removing Currency Sign from report figures

Former Member
0 Kudos

Hi,

Please any one has an idea on how I can prevent the currency sign from appearing on the body of the workbook.

I have column headers with the appropriate currency sign but I do not wish to see the key figure values appearing with the currency sign prefixed.

Your assistance will be appreciated.

Regards,

Uche

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member188975
Active Contributor
0 Kudos

Hi Uchenna,

You can also do this by using scaling factors.

Hope this helps...

Former Member
0 Kudos

Use 'NoDim(Keyfigure)' function in a new formula and check.

It's surely possible to eliminate currency unit using this NoDIm function.

thanks,

senthil kumar

Former Member
0 Kudos

Hi

create a new forumla with NoDim(key figure) and use that formula while hiding the orinigal key figure.

This will work.

Regards

Pradip

Former Member
0 Kudos

Hi,

Use 'NoDim(Keyfigure)' function in a new formula and check. Try out and see else it is not possible I beleiev. If it is in workbook you can refer teh data to a new sheet and format that column to remove the symbol.

Hope this helps you......