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.