Posted to microsoft.public.excel.programming

Ant

external usenet poster

Posts: 53

American date conversion Macro

Does anyone have some simple code (not formula) that I can use to convert
American date format to English format. eg. 12/25/06 to 25/12/06. It will
have to take into account single and double digits. I then want to be able to
attach the macro to a button for quick conversion.

Cheers,
Ant.

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
American date conversion macro	Ant	Excel Discussion (Misc queries)	7	July 15th 09 12:38 AM
Change from american date entry format	The Fru Fru	Excel Worksheet Functions	1	January 8th 09 04:52 AM
Date conversion	Charlie7805	Excel Worksheet Functions	4	March 4th 08 06:50 PM
Convert European Date format to American Format	Albert	Excel Discussion (Misc queries)	3	August 21st 07 10:02 PM
how can i change european date format to american	pclifford99	Excel Discussion (Misc queries)	11	November 28th 06 02:05 AM

All times are GMT +1. The time now is 05:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us