Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you could simply divide your number (and used possibly a numeric converting) like:
num#(NUMBER, '##########') / 100000
- Marcus
try to Format like this and put your numberfield instead of values
=num('1356000'/100000,'0,00$')
I think you could simply divide your number (and used possibly a numeric converting) like:
num#(NUMBER, '##########') / 100000
- Marcus
Thank you,
that was easy to do...
Both answers are good but I prefer to use the num#.