View Single Post
  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

If you just need it to display with the dash, choose the appropriate
format from the Format/Cells/Number/Special dialog.

If you actually need the - inserted, one way:

B1: =TEXT(A1,"00000-0000")

In article ,
Angela wrote:

I have zip codes in a field fields that I need to add a dash between the
first part of the zip and the second four numbers so the instead of looking
like "902101234", it looks like "90210-1234". How do I do this?