excel, how enter >15 digits in a cell without rounding off last?

M

mike marcus

How can I enter over 15 digits in a cell without it rounding off the excess
digits?
 
T

Toppers

You can't enter a numeric value > 15 digits so you need to format the cell as
TEXT but obviously you cannot use this for calculations.

Not for Credit Card Number by any chance?

HTH
 
M

MyVeryOwnSelf

How can I enter over 15 digits in a cell without it rounding off the
You can't enter a numeric value > 15 digits so you need to format the
cell as TEXT but obviously you cannot use this for calculations.
Click to expand...

Start with an apostrophe (').

As noted above, this makes a text value, not numeric. You can’t do
arithmetic with it the way you may expect.
 
M

mike marcus

No, transaction #'s and I don't need math calcs. So text is fine. I got it
now thanks
 
Top