add 2 decimal places
 

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?

Bill M. wrote:
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?

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!

Do you still want them to be text?

If not

=--(A1)/100

if text

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


Regards,

Peo Sjoblom



"Bill M." wrote:

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?