Thread: how do I turn off automatic truncation of long numbers in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do I turn off automatic truncation of long numbers in excel?
Excel has a 15 significant digits limitation on numbers.

Precede the long number with an apostrophe.

This makes the number text and cannot be used for calculations.


Gord Dibben MS Excel MVP

On Fri, 7 Aug 2009 08:32:01 -0700, paul n <paul
wrote:


Reply With QuoteReply With Quote