Simple question- please help!

[Mark31]

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.
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.

 

[Sandy Mann]

If it is for formnatting purposes then Custom format the cells as:

##-#####

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[L. Howard Kittle]

Try =LEFT(A1,2)&"-"& RIGHT(A1,4) copy down as far as needed.

Then copy - paste special - values to get rid of the formulas

HTH
Regards,
Howard

 

[Frederik]

Just create a new numerical format 00-0000.

 

[Minx]

A Custom Format that looks something like 00-#### should do what you want.

Select your column, right-click and select Format Cells. The first tab is
"Number". Custom is at the bottom of the left-hand list.
HTH

 

[Mark31]

Thanks a lot, your replies were very helpful!