Dividing by 100 when I don't want it!!!

  • Thread starter Thread starter Dormouse
  • Start date Start date
D

Dormouse

When I put numbers in a cell in excel, they are automatically divided by
100, yet there is no formula in the cell. Which button have I activated to
do this or what may I have done by mistake? Thanks for your help.

Dormouse
 
Tools->Options->Edit and untick the "Fixed Decimal" box

--
Regards;
Rob

Please reply to the NG, I'm already up to my eyeballs in Nigerian/South
African get rich letters
as well as "Microsoft Critical Updates" et al.
 
Back
Top