| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Percentage format
Hello, in Excel 2000 how do I prevent Excel from multiplying percentage
numbers by 100? In other words, if I type 5% in a cell, I do not want Excel to multiply it by 100 so it shows as 500% - I want it to remain as 5%. Thanks. Regards, Randy |
|
#2
|
|||
|
|||
|
Randy wrote:
|| Hello, in Excel 2000 how do I prevent Excel from multiplying || percentage numbers by 100? In other words, if I type 5% in a cell, I || do not want Excel to multiply it by 100 so it shows as 500% - I want || it to remain as 5%. Thanks. || || Regards, || || Randy Format the cell as General or Number - NOT Percent. -- Gordon Burgess-Parker Interim Systems and Management Accounting www.gbpcomputing.co.uk |
|
#3
|
|||
|
|||
|
FIrst Format - Cells... -Percentage -. OK
then enter 5% -- Gary's Student "Randy" wrote: Hello, in Excel 2000 how do I prevent Excel from multiplying percentage numbers by 100? In other words, if I type 5% in a cell, I do not want Excel to multiply it by 100 so it shows as 500% - I want it to remain as 5%. Thanks. Regards, Randy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I preserve the numerical percentage format whe I do mailme. | Excel Discussion (Misc queries) | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
| How can I conditional format to show either a percentage or a whol | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| Percentage format | Excel Worksheet Functions | |||
Linear Mode
