Percentage format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top