How do you convert existing numbers?
 

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?

How do you convert existing numbers?
 

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

"Hobbi" wrote:

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?

How do you convert existing numbers?
 

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

"Hobbi" wrote:

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?

How do you convert existing numbers?
 

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

Hobbi wrote:
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?

How do you convert existing numbers?
 

GACK! Divide not Multiply!

Bob I wrote:

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

Hobbi wrote:

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?

How do you convert existing numbers?
 

Great- Thanks everyone!

"Tom Hutchins" wrote:

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

"Hobbi" wrote:

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?