Posted to microsoft.public.excel.misc

jason2444

Posts: n/a

Formating years.

have a csv file that in one column has years 89-99, 99-04 can I format that
column so that it changes those years to 1989-1999, 1999-2004

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Convert years to years and days	Kimmie B	Excel Discussion (Misc queries)	3	February 7th 06 08:06 PM
Years of Service Question?	Kane	New Users to Excel	2	February 3rd 06 03:05 PM
Data Range Mess	Karen	Charts and Charting in Excel	18	January 14th 06 02:34 PM
To create formula to add 3 years and subtract 1 day from a date?	rostroncarlyle	Excel Worksheet Functions	2	December 8th 05 11:21 PM
I need the difference between two dates expressed as 4 years 3 mo.	Dean	Excel Discussion (Misc queries)	2	December 1st 05 05:11 AM

All times are GMT +1. The time now is 07:06 PM.

About Us

"It's about Microsoft Excel"