% pain

  • Thread starter Thread starter Danny J
  • Start date Start date
D

Danny J

I am being silly but is there a way of setting a workshhet so that when I
type in 4.9 in a percentage formatted cell it does not appear as 490%? I
suppose I could set the cell format to general and type in 4.9% but I am
worried that the calculations might not work, excel reading the cell as
text.

Thanks,

Danny
 
Hi Danny,

Tools>Options>Edit, check Enable automatic percent entry

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top