How can I stop all numeric entries from being devided by 100?
 

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

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.

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.