Re: Stop Rounding Last Digit of 16 Digit Numbers

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 11:27:51 -0700

Since you're probably entering a credit card or similar number that you
will never do math on, either preformat the cell as text or prefix it
with an apostrophe (') when you enter it.

XL's precision is 15 decimal digits, so if you need to do math on it,
you'll either need to use a different application, or get one of the
commercial add-ins that extend XL's precision.

In article <42b6ce63.0403301020.d467666@posting.google.com>,
 office@gp.org (erc) wrote:

> I am trying to enter 16 digit numbers into a column but the program is
> rounding the last digit to a zero. How do I stop it from rounding the
> last digit? HELP!!!

Quantcast