Thread: How do I display numbers of 12 digits or more?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jaxboo Jaxboo is offline
external usenet poster
  
Posts: 4
Default How do I display numbers of 12 digits or more?
tried that before posting. It still takes any number over 12 and changes it
to zero.

"jlclyde" wrote:

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