Prev: can't get excel to print more than one copy of worksheet at atim
Next: Pivot Table- Column 2 sort
From: Max T. Max on 20 Jan 2010 12:32
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.)
From: Mike H on 20 Jan 2010 12:40
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.)
 | 
Pages: 1
Prev: can't get excel to print more than one copy of worksheet at atim
Next: Pivot Table- Column 2 sort