Are there always 3 decimals and do you always want it to be an integer
where those decimals are converted into integers? If so just multiply
your number with 1000, one way

put 1000 in an empty cell, copy it, select the numbers you want to
change, do editpaste special and select multiply



Regards,

Peo Sjoblom

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