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

B

Bob

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

Bill Kuunders

go to

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

Greetings from New Zealand
Bill K
 
B

Bob Phillips

Tools>Options>Edit, uncheck the Fixed decimal box

--

HTH

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