When 1 inserted in cell 0.01 displayed

  • Thread starter Thread starter Louise C
  • Start date Start date
L

Louise C

Hi There,

Looking for a little help! When ever I insert 1 into a
worksheet 0.01 is displayed and I have no idea why. Any
ideas?

Thanks in advance

Louise
 
Go to the Tools menu, choose Options, then the Edit tab. There,
uncheck the "Fixed Decimal" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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

Reference to another worksheet cell in a sumproduct formula 1
How to display the value in different format? 7
Input numbers appearing incorrectly on spreadsheet 2
Table Lookup 4
Entering a number in any cell eg. 1 it changes to 0.01 why 3
complex count formulas using multiple criteria in different ranges 4
How to determine the value? 2
Help with normal distribution, generating ratios for bell-shape cu 5

Back
Top