Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing % to whole numbers
I have a number of very large spreadsheets all with percentages. I want to
change the cells from % to whole numbers. I did this the other day and it was obviously something very simple (for me it has to be simple) but for some reason I have gone completely brain dead and can't remember what I did. My example is, say 12%. When I change it to the number format I get 0.12. Obviously if I take away the 2 decimal places I end up with 0. I want to end up with the number displayed as 12. Thanks in advance. |
#2
|
|||
|
|||
Answer: Changing % to whole numbers
To change a cell from a percentage to a whole number, follow these steps:
This should convert your percentages to whole numbers. For example, if you had a cell with the value "12%", it would now display as "12". If you need to use this formula in your Excel sheet, you can wrap it in the [code] tag like this: Code:
=A1*0.15 Formula:
Formula:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing % to whole numbers
Try this:
Put 100 in a blank cell and format that cell the way you want the converted numbers to display (eg Number, 0 decimal places) Copy the cell Select the range of percent cells <edit<paste special....Check: Multiply......Click [OK] <edit<paste special....Check: Formats......Click [OK] Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Lynda" wrote in message ... I have a number of very large spreadsheets all with percentages. I want to change the cells from % to whole numbers. I did this the other day and it was obviously something very simple (for me it has to be simple) but for some reason I have gone completely brain dead and can't remember what I did. My example is, say 12%. When I change it to the number format I get 0.12. Obviously if I take away the 2 decimal places I end up with 0. I want to end up with the number displayed as 12. Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing % to whole numbers
Lynda,
Put 100 in an empty cell and copy that cell. Select all your percentages and then Edit|Paste Special|Multiplt and click OK. Delete the cell with 100 in Mike "Lynda" wrote: I have a number of very large spreadsheets all with percentages. I want to change the cells from % to whole numbers. I did this the other day and it was obviously something very simple (for me it has to be simple) but for some reason I have gone completely brain dead and can't remember what I did. My example is, say 12%. When I change it to the number format I get 0.12. Obviously if I take away the 2 decimal places I end up with 0. I want to end up with the number displayed as 12. Thanks in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing % to whole numbers
Several different ways. One way:
for no decimals: =TEXT(A2*100,"0") for decimals: =TEXT(A2*100,"0.00") Another way: Enter 100 into a blank cell somewhere Select the cell and copy it Select the range containing the percentages Edit--Paste Special Under operation, select Multiply Click OK Lynda wrote: I have a number of very large spreadsheets all with percentages. I want to change the cells from % to whole numbers. I did this the other day and it was obviously something very simple (for me it has to be simple) but for some reason I have gone completely brain dead and can't remember what I did. My example is, say 12%. When I change it to the number format I get 0.12. Obviously if I take away the 2 decimal places I end up with 0. I want to end up with the number displayed as 12. Thanks in advance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing % to whole numbers
One way
Sub makepercentwhole() For Each c In Range("i3:i14") If IsNumeric(c) Then c.Value = c * 100 c.NumberFormat = "0.00" Next End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Lynda" wrote in message ... I have a number of very large spreadsheets all with percentages. I want to change the cells from % to whole numbers. I did this the other day and it was obviously something very simple (for me it has to be simple) but for some reason I have gone completely brain dead and can't remember what I did. My example is, say 12%. When I change it to the number format I get 0.12. Obviously if I take away the 2 decimal places I end up with 0. I want to end up with the number displayed as 12. Thanks in advance. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing % to whole numbers
Thank you all so much for your help and prompt reply, I will be able to sleep
now. "Lynda" wrote: I have a number of very large spreadsheets all with percentages. I want to change the cells from % to whole numbers. I did this the other day and it was obviously something very simple (for me it has to be simple) but for some reason I have gone completely brain dead and can't remember what I did. My example is, say 12%. When I change it to the number format I get 0.12. Obviously if I take away the 2 decimal places I end up with 0. I want to end up with the number displayed as 12. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbers changing | Excel Discussion (Misc queries) | |||
Changing column of numbers made of formulas to just numbers | Excel Discussion (Misc queries) | |||
Changing Row Numbers | Excel Discussion (Misc queries) | |||
Changing numbers | Excel Discussion (Misc queries) | |||
Changing Numbers | Excel Worksheet Functions |