Excel 2008 : How to add a - in between numbers

[Madirish]

cell A looks like below. I need to add - after the 603 all the way down so it will look like this 603-20001 how can I do this quickly.
A
60320001
60320004
60320009
60320017
60320102
60320105
60320107
60320109
60320204
60320207
60320208
60320209
60320304
60320307
60320308
60320309
60320402
60320405
60320407
60320408

[Marcol]

Try in B2

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[AndyPS]

Why not use replace "603" with "603-"?

[JBeaucaire]

1) Highlight the column of values
2) Press CTRL-1 to open the formatting window
3) Apply a Custom number format of 000-00000

This will make the numbers LOOK like 603-20001, but won't actually change the values in the original cells.

[Marcol]

@ Andy That will replace all instance of 603 e.g. 60320603 > 603-20603-, or e.g. 60326035 > 603-2603-5

@ Jerry Okay, the operative words are "...it will look like this 603-20001", missed that!