Why not multiply by 1000?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rab Swinney" wrote in message
...
How do I remove a decimal place to return the following

0900.000 to 0900000
I know I can use the left and right function and & them, the problem is
the
first 4 digits can be 5 or 6 digits