View Single Post
  #1   Report Post  
Mark31 Mark31 is offline
Junior Member
 
Posts: 3
Default Simple Question - Please Help!

I have a column of data that contains a 7 digit number in each row. I need to insert a hyphen after the 2nd number for formatting purposes for the entire column. Any easy way to do it? I am getting tired of the copy and paste. Example below

As it looks now:
990000
990001

How I need it to look:
99-0000
99-0001

Thanks.

Last edited by Mark31 : November 26th 07 at 06:58 PM