Posted to microsoft.public.excel.programming

PhilM

external usenet poster

Posts: 6

Changing Date Formats in VBA

Hi

I have a date format of dd/mm/yyyy in a string (ie 02/10/2006) for
filename purposes to save my file I need this to format as "2nd October
2006" how can I do this?

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
changing date formats	Susan	Excel Discussion (Misc queries)	1	July 23rd 09 02:23 AM
changing date formats	Heine	Excel Worksheet Functions	4	May 3rd 07 03:54 PM
Changing date formats?	lakegoddess	Excel Discussion (Misc queries)	5	January 6th 06 05:26 PM
Changing Imported Date Formats	Craig Lloyd	Excel Worksheet Functions	5	December 20th 05 02:30 PM
Changing Imported Date Formats	Craig Lloyd	Excel Worksheet Functions	0	December 20th 05 12:51 PM

All times are GMT +1. The time now is 10:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us