| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert existing excel numbers to negative? | Excel Discussion (Misc queries) | |||
| Adding numbers or characters to existing numbers | Excel Worksheet Functions | |||
| How to convert existing Excel List into a table in Access? | New Users to Excel | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
Hybrid Mode
