Tags: cell, chages, enter, excel, excell, hit, leave, microsoft, msdn, msexcell, number, numbers, software, sp3, string

Why does Excell change my last number to "0" in a string?

On Microsoft » Microsoft Excel

1,212 words with 1 Comments; publish: Thu, 22 May 2008 18:45:00 GMT; (30693.75, « »)

In MSExcell 2002 SP3. In a cell I enter a string of numbers, ie..1658618353,

then when I leave that cell or hit "enter" the last number chages to "0"

ie... 1658618350.

I have tried reformatting the cell, deleting the info and re-entering it,

and everything I could find in "help".

All Comments

Leave a comment...

  • 1 Comments
    • Is that your credit card number ? Thank you.. :)

      Seriously, excel has 15 digit precision and anything more than that will be

      truncated to a zero, if you need to store numbers greater than 15 digits

      preformat cell(s) as text or precede the entry with an apostrophe '

      Regards,

      Peo Sjoblom

      Northwest Excel Solutions

      www.nwexcelsolutions.com

      (remove ^^ from email address)

      Portland, Oregon

      "dlooney2006" <dlooney2006.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:D5F8DFAD-4353-40E5-B9D4-72D2271CFDBA.excel.todaysummary.com.microsoft.com...

      > In MSExcell 2002 SP3. In a cell I enter a string of numbers,

      > ie..1658618353,

      > then when I leave that cell or hit "enter" the last number chages to "0"

      > ie... 1658618350.

      > I have tried reformatting the cell, deleting the info and re-entering it,

      > and everything I could find in "help".

      #1; Thu, 22 May 2008 18:46:00 GMT