Thread: How do I prevent the cell from changing the number I enter?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I prevent the cell from changing the number I enter?
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

On Fri, 26 Jun 2009 07:26:02 -0700, Littlestar29
wrote:

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?

Reply With QuoteReply With Quote