First, just multiply by 1000
2nd, change the formating from 0000.000 to just "Number"


"Rab Swinney" wrote:

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