Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
percents
Hi,
I have a list of numbers that i would like to show as percents. Lets say I have 40 and I want it to show 40% and not 4000%. How do I do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
percents
Hi,
1. Put 0.01 in a cell and copy it. Select your numbers and then Edit|Paste special, select multiply and click OK. 2. Format as % 3. Delete the 0.01. Mike "assaf1978" wrote: Hi, I have a list of numbers that i would like to show as percents. Lets say I have 40 and I want it to show 40% and not 4000%. How do I do that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
percents
There are two ways:
1. Format Cells... Number Custom General% This will change the display, but not the value 2. divide the cells by 100 and then: Format Cells... Number Percentage This will change both the value and the display. -- Gary''s Student - gsnu200811 "assaf1978" wrote: Hi, I have a list of numbers that i would like to show as percents. Lets say I have 40 and I want it to show 40% and not 4000%. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percents | Excel Worksheet Functions | |||
Percents | Excel Discussion (Misc queries) | |||
Percents and Text in one cell - need to add percents only | Excel Discussion (Misc queries) | |||
Percents | Excel Discussion (Misc queries) | |||
Formula - Percents | Excel Discussion (Misc queries) |