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

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

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