Thread: How do I display numbers of 12 digits or more?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
  
Posts: 410
Default How do I display numbers of 12 digits or more?
On Nov 20, 10:45 am, Jaxboo wrote:
Excel keeps taking any digit over 11 and displays them as zero's, Is there
anyway to prevent this? I have tried custom formats to no avail.

Go to Custom formats and type # for as many numbers as you want
displayed.

Jay
Reply With QuoteReply With Quote