View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Custom Format Limitation

Numbers have a fundamental limitation of 15 digits. To get more than 15
digits, precede the value with an apostrophe (single quote)
--
Gary''s Student - gsnu2007b


"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.