go to

tools-options-edit and uncheck "fixed decimal places"

Greetings from New Zealand
Bill K
"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.