Junior Member

Posts: 3

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Simple question- please help!	Mark31	Excel Discussion (Misc queries)	5	November 27th 07 02:41 PM
simple Question	Mo2	New Users to Excel	1	May 3rd 07 06:08 AM
a very simple question	[email protected]	Excel Discussion (Misc queries)	6	November 6th 05 02:50 PM
Simple Simple Excel usage question	BookerW	Excel Discussion (Misc queries)	1	June 23rd 05 10:06 PM
Simple VBA question	Mark1	Excel Discussion (Misc queries)	1	November 30th 04 10:25 PM

All times are GMT +1. The time now is 02:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us