Num Format

[manoranjan_d]

Hi,

I have dollar value as 175082602.59  and I am dividing this with 1000000000, now i want to display it as 1.75$

how to do this num format

[manoranjan_d]

I using text box to show this value as 1.75$ but how to do this in num format, i used

[santhoo_san]

=num(175082602.59/100000000,' #0.00$')

[manoranjan_d]

so if if i got 111.56 then i shd add one more hash # like this '##0.00'

[susovan]

Hi manoranjan,

Try this,

[avinashelite]

As per my knowledge it will dynamically populate , try with your data and if your facing any issues let us know

[nizamsha]

IF u are using text object use this one

=Num(sum(175082602.59 )/10000000,'$#,##0.00')

incase if u are using any table mean go to the number format tab and click the money format and change the currencies based on the requirement

[nizamsha]

that will populate dynamically it depends on what you are dividing  you have  your data in cr so u are dividing it by cr

[stevedark]

Note that in the number format a hash represents a digit that might be there, whilst a zero denotes one that must be there.  So, for dollar values you should use:

#,##0.00$

This will ensure two digits after the decimal, and at least one before.  There will then be recurring sets of three digits separated by commas.

Hope that helps.

Steve