How do you convert existing numbers?

[Hobbi]

I have a large column of numbers that need to changed to currency. I want to
add decimal points to the amounts already listed, not add decimals and zeros
at the end. Example change 15000 to 150.00 and 1920 to 19.20. Is there a way
to change with without manually doing all the numbers?

 

[Tom Hutchins]

Enter 100 in an unused cell. Select that cell, then select Edit >> Copy. Now
select your large range of numbers to be changed. Select Edit >> Paste
Special. On the Paste Special dialog, select Divide in the Operation section,
then click OK.

Hope this helps,

Hutch

 

[Elisabeth D]

one way:

Enter 100 in an empty cell and then copy that cell
Select all of the figures you want to change
Edit > Paste Special > Divide

 

[Bob I]

Put 100 in a cell copy it, select your number list, Paste special, and
select Multiply.

 

[Bob I]

GACK! Divide not Multiply!

Put 100 in a cell copy it, select your number list, Paste special, and
select Multiply.

 

[Hobbi]

Great- Thanks everyone!

Enter 100 in an unused cell. Select that cell, then select Edit >> Copy. Now
select your large range of numbers to be changed. Select Edit >> Paste
Special. On the Paste Special dialog, select Divide in the Operation section,
then click OK.

Hope this helps,

Hutch