Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number formatting issue
I have table with extensive entries (which I inheriited) that are formatted
as general numbers (ie 92.1 or 10.6) when they really are percentages. I am adding current data to them, but the cut and paste process brings the new data correctly, as percentages. I have tried changing new entries to match by dropping the percent sign, but that doesn't do it, and I have tried changing the old data to percents, but it formats them incorrectlt (ie 71.6 becomes 7160%) I am not a mathmetician - and maybe there isn't any way to work this out, but I am having to hand enter every number. Any help out there??? Thanks |
#2
|
|||
|
|||
Hi,
The following is a way to convert your old numbers. In an unused cell type 1.0% Decrease the decimal place to 1 if required. Copy that cell and select all of the values you wish to convert (Hold CTRL key down if required). Go to EditPaste Special and choose Multiply. Click OK. HTH, Matt "Gayle" wrote: I have table with extensive entries (which I inheriited) that are formatted as general numbers (ie 92.1 or 10.6) when they really are percentages. I am adding current data to them, but the cut and paste process brings the new data correctly, as percentages. I have tried changing new entries to match by dropping the percent sign, but that doesn't do it, and I have tried changing the old data to percents, but it formats them incorrectlt (ie 71.6 becomes 7160%) I am not a mathmetician - and maybe there isn't any way to work this out, but I am having to hand enter every number. Any help out there??? Thanks |
#3
|
|||
|
|||
Before copying in the new percentages try this on the old data:
Assume that the 'old percentages' are in column A and start on row 1. In B1 just type =A1/100, and drag that all the way down to the bottom of your 'old percentages' list. Then, copy the data in column B and paste only the values (right click - paste special - Values) into column A. Then format them as percentages and it should work out. - Dave "Gayle" wrote: I have table with extensive entries (which I inheriited) that are formatted as general numbers (ie 92.1 or 10.6) when they really are percentages. I am adding current data to them, but the cut and paste process brings the new data correctly, as percentages. I have tried changing new entries to match by dropping the percent sign, but that doesn't do it, and I have tried changing the old data to percents, but it formats them incorrectlt (ie 71.6 becomes 7160%) I am not a mathmetician - and maybe there isn't any way to work this out, but I am having to hand enter every number. Any help out there??? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number formatting - what's going on? | Excel Discussion (Misc queries) | |||
number formatting question | Excel Worksheet Functions | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) |