Why does 26000 display as 260.00 after formatting for numbers

S

shiv

Although the cells have been formatted for numbers, entries are displayed as
one hundredth of the keyed in number.
How do I get the displayed number to be exactly as keyed in?
 
B

Bob Phillips

Go to Tools>Options>Edit and see if the Fixed decimal box is checked. If so,
uncheck it.

--

HTH

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