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

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - how do I turn off automatic truncation of long numbers in excel? (https://www.excelbanter.com/setting-up-configuration-excel/239228-how-do-i-turn-off-automatic-truncation-long-numbers-excel.html)

paul n

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

Gord Dibben

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:

All times are GMT +1. The time now is 06:23 PM.