how do I turn off automatic truncation of long numbers in excel?

  • Thread starter Thread starter paul n
  • Start date Start date
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
 
Back
Top