Hi

You could use a custom format such as:

[<100000]00000-"0000";00000-0000

which should force the correct format.

Hope this helps!

Richard


On 5 Mar, 14:14, dandiehl wrote:
If you format a cell to use the Zip code +4 format, and you only enter the
5-digit code, Excel displays the entry as 00001-2345. Is there a way to
force the leading zeros to become trailing zeros? I would like it to display
as 12345-0000.