software

Good Morning:
I would appreciate any help with the following problem:
I am using XP OS and Excel 2002.
I need to enter a series of numbers (which are really text since no
calculation will be needed). For instance I might need to add the
following:
4000-5002-4911-1567

I created a custom format cell of 0000quot;-quot;0000quot;-quot;0000quot;-quot;0000

When I enter 4000500249111567 it displays 4000-5002-4911-1560 . The
custom format appears to be rounding all my last digits to zero.

Thanks in advance, for any help.That is because you are coming up against Excel precision limits, 15 digits.

If you want text, best to enter it as text with the hyphens included.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Bobbiequot; gt; wrote in message oups.com...
gt; Good Morning:
gt; I would appreciate any help with the following problem:
gt; I am using XP OS and Excel 2002.
gt; I need to enter a series of numbers (which are really text since no
gt; calculation will be needed). For instance I might need to add the
gt; following:
gt; 4000-5002-4911-1567
gt;
gt; I created a custom format cell of 0000quot;-quot;0000quot;-quot;0000quot;-quot;0000
gt;
gt; When I enter 4000500249111567 it displays 4000-5002-4911-1560 . The
gt; custom format appears to be rounding all my last digits to zero.
gt;
gt; Thanks in advance, for any help.
gt;