Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding?

  • Thread starter Thread starter Max T.
  • Start date Start date
M

Max T.

When I enter a 16 digit credit card number, excel rounds the last digit to 0;
How do I format to reatin the exact number I entered (Have formatted cells to
numbers, no decimal places now.)
 
Hi,

Format as text or precede your number with an apostrophe; it won't show up
in the cell.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top