add 2 decimal places

B

Bill M.

I have a column of numbers which were imported as text and need to have the
last two places changed to decimals. How do I do that?
 
G

Gordon

Bill said:
I have a column of numbers which were imported as text and need to have the
last two places changed to decimals. How do I do that?
Click to expand...

Type in the number 10 in a spare cell. highlight it, select "copy" then
select the column you wish to change, right-click on it, select "paste
Special" and under "Operation" choose divide.

HTH


--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
 
P

Peo Sjoblom

Do you still want them to be text?

If not

=--(A1)/100

if text

=TEXT(--(A2)/100,"@")


Regards,

Peo Sjoblom
 
Top