Posted to microsoft.public.excel.programming

douvid

external usenet poster

Posts: 10

date formatting

Hi ,
I got a string like "20030101" and I want this to become the date 01 jan 03 . I can't figure it out. Can you please help if this action is possible

Cheers,
Douvid

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
conditional formatting for cell date to equal today's date	Sistereinstein	Excel Worksheet Functions	2	September 10th 12 07:53 PM
Date Formatting	Mike H	Excel Discussion (Misc queries)	1	May 27th 10 10:22 PM
Date Formatting	TheRiverT	Excel Discussion (Misc queries)	4	August 7th 09 08:46 PM
Date Formatting	Des1313	Excel Discussion (Misc queries)	1	March 13th 07 09:23 PM
date formatting	BernieH	Excel Discussion (Misc queries)	2	May 30th 05 03:33 PM

All times are GMT +1. The time now is 02:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us