Custom Format Limitation
Excel is capable of using only 15 significant digits.
After 15 digits, zeros will appear.
More can be shown if you enter the digits as text but then you could not
calculate with them.
Gord Dibben MS Excel MVP
On Mon, 3 Dec 2007 12:32:58 -0700, "David Steed" wrote:
There appears to be a limitation on the number of # characters you can use
in a custom format. Is this true? We keep running out of calculated
results at 15 with the 16th zero. Any help appreciated.
|