This looks like a zip code, is it? If so, you can just format it as such...
Format-Cells-'Number' Tab-Special-"Zip Code + 4"

Otherwise you can use this formula:
=CONCATENATE(LEFT(A1,5),"-",RIGHT(A1,4))

Change the A1 reference to match your data.


--
Regards,
Dave


"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?