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

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

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

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

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

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

If your original number (0900.000) is text, the following might do the
job for you:

=substitute(A1,".","")