ToolsOptionsEdit, uncheck the Fixed decimal box

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob" wrote in message
...
In a new and existing sheets, all numeric entries are being devided by
100.
Tools-Options-Edit-Enable automatic percent entry is turned off.