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

[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

 

[RWN]

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.

 

[Dormouse]

Thanks very much both of you. The solution works fine.

Dormouse