Add comma inside number

[#1]

Hi All,

I have a number stored in my database, example :

"935000" mean "9.35$"

"1356000" mean "13.56$"

So I have to delete the three '0' and insert a comma before the two decimal numbers, but I don't know how to do this, num# and num don't seems to allow me do this, anyone have a solution ?

Thank you fro you help,

Loup

[Anonymous]

try to Format like this and put your numberfield instead of values

=num('1356000'/100000,'0,00$')

[marcus_sommer · Accepted solution]

I think you could simply divide your number (and used possibly a numeric converting) like:

num#(NUMBER, '##########') / 100000

- Marcus

[#4]

Thank you,

that was easy to do...

Both answers are good but I prefer to use the num#.