View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers Mike Rogers is offline
external usenet poster
 
Posts: 194
Default 17 digit number not inserted

hit44

XL can only recognize 15 digits as numbers, the only way XL can hold more
is if it is the form of text. Either format the cell as text, or insert a
single quote ' in front of your 17 digit entry.

Does this help?

Mike Rogers

"hit44" wrote:

I am totaling a number and the cell does not accept more than 15 digits.
Please help????
Thank you in advance Have a good day