Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have an existing spreadsheet, and I need to format existing numbers in the
cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I right click on the cell to format and choose number and 2 decimal places, it adds zeros (515.00 or 72957.00) Is there ANY way to do this?? |
#2
![]() |
|||
|
|||
![]()
Can you just divide them all by 100?
"Robin" wrote: I have an existing spreadsheet, and I need to format existing numbers in the cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I right click on the cell to format and choose number and 2 decimal places, it adds zeros (515.00 or 72957.00) Is there ANY way to do this?? |
#3
![]() |
|||
|
|||
![]()
Robin
This is not just a formatting issue. You need to actually change the values. Enter 100 in an empty cell. Copy that cell. Select your numbers and Paste SpecialDivideOKEsc. Clear the cell with 100. Gord Dibben Excel MVP On Wed, 2 Mar 2005 17:19:03 -0800, "Robin" wrote: I have an existing spreadsheet, and I need to format existing numbers in the cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I right click on the cell to format and choose number and 2 decimal places, it adds zeros (515.00 or 72957.00) Is there ANY way to do this?? |
#4
![]() |
|||
|
|||
![]()
On Wed, 2 Mar 2005 17:19:03 -0800, "Robin"
wrote: I have an existing spreadsheet, and I need to format existing numbers in the cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I right click on the cell to format and choose number and 2 decimal places, it adds zeros (515.00 or 72957.00) Is there ANY way to do this?? If I understand you correctly, you want to DIVIDE the existing numbers by 100. In some blank cell, enter the number 100 and select that cell. Edit/Copy Select the existing numbers Edit/Paste Special Operation Divide --ron |
#5
![]() |
|||
|
|||
![]()
I am unsure what you mean by this: Select your numbers and Paste
SpecialDivideOKEsc? "Gord Dibben" wrote: Robin This is not just a formatting issue. You need to actually change the values. Enter 100 in an empty cell. Copy that cell. Select your numbers and Paste SpecialDivideOKEsc. Clear the cell with 100. Gord Dibben Excel MVP On Wed, 2 Mar 2005 17:19:03 -0800, "Robin" wrote: I have an existing spreadsheet, and I need to format existing numbers in the cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I right click on the cell to format and choose number and 2 decimal places, it adds zeros (515.00 or 72957.00) Is there ANY way to do this?? |
#6
![]() |
|||
|
|||
![]()
I figured it out............wow, thanks so much! That will save me lot's of
work.... "Gord Dibben" wrote: Robin This is not just a formatting issue. You need to actually change the values. Enter 100 in an empty cell. Copy that cell. Select your numbers and Paste SpecialDivideOKEsc. Clear the cell with 100. Gord Dibben Excel MVP On Wed, 2 Mar 2005 17:19:03 -0800, "Robin" wrote: I have an existing spreadsheet, and I need to format existing numbers in the cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I right click on the cell to format and choose number and 2 decimal places, it adds zeros (515.00 or 72957.00) Is there ANY way to do this?? |
#7
![]() |
|||
|
|||
![]()
Good stuff!
Thanks for the feedback. Gord On Wed, 2 Mar 2005 17:45:02 -0800, "Robin" wrote: I figured it out............wow, thanks so much! That will save me lot's of work.... "Gord Dibben" wrote: Robin This is not just a formatting issue. You need to actually change the values. Enter 100 in an empty cell. Copy that cell. Select your numbers and Paste SpecialDivideOKEsc. Clear the cell with 100. Gord Dibben Excel MVP On Wed, 2 Mar 2005 17:19:03 -0800, "Robin" wrote: I have an existing spreadsheet, and I need to format existing numbers in the cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I right click on the cell to format and choose number and 2 decimal places, it adds zeros (515.00 or 72957.00) Is there ANY way to do this?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel, how to sum top 10 greatest values in a row of numbers? | Excel Worksheet Functions | |||
I have a set of numbers in an excel spreadsheet and want to find t | Excel Discussion (Misc queries) | |||
Excel Date Format - Stop? | Excel Worksheet Functions | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
How do I stop virus scans when loading existing Excel files?? | Excel Worksheet Functions |