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

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

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

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.


"Max T." wrote:

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