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
|