software

How do you enter a 16 digit number without adding extra numbers on the end or
displaying a formula? I have tried all the Format Cells options with no luck.
Many Thanks!

Excel can cope with 15 digits.
Assuming your 'number' is something like a bank account number and no math
will be done on the number: type an apostrophe before entering the number;
e.g. '1234567887654321

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;GrlsWthCrlsquot; gt; wrote in message
...
gt; How do you enter a 16 digit number without adding extra numbers on the end
gt; or
gt; displaying a formula? I have tried all the Format Cells options with no
gt; luck.
gt; Many Thanks!

Format your cell as text or put an anpostrophe in front of your
numbers.

i.e
'12345678912345678

Regards
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498808