Is the value a TEXT value or is it a number with a custom format?

A1 = (TEXT value) 0900.000

=SUBSTITUTE(A1,".","")

Returns TEXT value 0900000

Biff

"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