Custom Cell Format

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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 0000"-"0000"-"0000"-"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.

.

Relevant Pages

  • Re: 16th digit changes?? Problem,16th digit changes to a zero....
    ... Microsoft MVP - Excel ... > numerical digits long. ... get changed to end with a zero instead of the real number. ... > into excel and noticed that the 16th digit gets changed everytime to a ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I stop Excel from changing last digit in a number entry?
    ... Excel can only show up to 15 digits of precision, ... changes the last digit to a zero. ...
    (microsoft.public.excel.newusers)
  • Re: Calc error
    ... Kind regards, ... > further digits. ... > Is correctly calculated by Excel as 4.74 in cell a3. ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Social Security Numbers & Leading Zeros
    ... Wasn't aware that social security numbers could begin with a zero ... 16 digits and Excel only handles 15 significant digits so you must ... My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm ... > I imported over 3000 records that are tied to social security numbers. ...
    (microsoft.public.excel.misc)
  • zero value
    ... >How do you add a zero in front of a number in excel ... without it disappearing? ... if the number remains constant ie: 4 digits ...
    (microsoft.public.excel.misc)