Thread: The lastdigit of 16digit numberschanges to 0. How do I stop this?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trumpeter
 
Posts: n/a
Default The lastdigit of 16digit numberschanges to 0. How do I stop this?
I'm using Excel 2000 and need to use 16 digit numbers. However I find that
the last digit automatically changes to a zero. For instance typing
5434603057707214 to a cell is changed to 5434603057707210 when I hit enter.
Is there a way to stop this?
Reply With QuoteReply With Quote