Tools|Options|Edit tab|uncheck fixed decimal places.

Lots of accounting type people like this to make data entry easier.

(Normal people <vbg hate it!)

Neal Henzler wrote:

Strange problem popped up today - independent of the working in use - a new
blank, new from a template, or previous sheet - every whole number is
replaced by 1/100 of that number - ie, 1 is replaced by 0.01, regardless of
cell format. This is isolated to my computer. Excel has been
removed/reinstalled, updated, run excel.exe /unregserver & then /regserver -
no change. There are no hidden macros. Aaargh! Hard to get any work done!
Please help!

--

Dave Peterson