convert 200701 to Jan-07

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 54

convert 200701 to Jan-07

Hi

I have raw data with a date in the format 200701 (as extracted from DB).
Does anyone know how I can conver this to Jan-07?

Thanks

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
can the "convert" function in excel convert to UK gallons?	JR	Excel Discussion (Misc queries)	2	April 24th 08 04:55 PM
how will i convert 05.01.2007 convert 05.Jan.2007 format?	lady_like	New Users to Excel	17	February 9th 07 12:43 PM
convert value in word. For Exampe Rs.115.00 convert into word as .	Shakti	Excel Discussion (Misc queries)	1	May 10th 05 12:00 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m	agenda9533	Excel Discussion (Misc queries)	8	January 20th 05 10:24 PM
Convert Time...!convert tenths of a second	Pape	Excel Discussion (Misc queries)	2	December 16th 04 10:17 AM

All times are GMT +1. The time now is 03:37 PM.

About Us