How do I prevent the cell from changing the number I enter?

  • Thread starter Thread starter Littlestar29
  • Start date Start date
L

Littlestar29

Everytime I enter a number (18 digits) into the cell it changes it to a
different number. I've tried changing the number format in the formatting
menu and that didn't solve it (went into Format, Cells, Number and selected 0
decimal places). Does anyone know how to fix this?
 
OR Format the cells/column as text. Right click>Format cells>Select
Text...before entering the number...
 
Excel has only 15 digits of precision.

After 15 digits it will replace with zeros.

See other replies for workarounds.


Gord Dibben MS Excel MVP
 

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

Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Stop XL from changing format? 1
I cannot enter a number containing more than 15 digits in Excel 1
Excel 2007 automatically corrupts my data!! 1
How do I stop Excel from copying date format from cell above? 2
Excel 2003 keeps on changing the date that i entered. HELP PLEASE 1
How many number digits can I fit into one cell? 3
How to restrict zeros in a number from 16th digit onwards 5

Back
Top