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

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.)
 
M

Mike H

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.
 
Top