Why does 26000 display as 260.00 after formatting for numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number format 1
Custom Number Format for text 8
Decimal points data not displaying as expected 2
Numbers showing Up Centered in Cell ? 1
formatting negative numbers 1
Custom Format on 16 Digit Number 5
I cannot enter a number containing more than 15 digits in Excel 1
Format Cell as custom type but data doesn't display like I custom. 6

Back
Top