Posted to microsoft.public.excel.programming

nicole3208 nicole3208 is offline

external usenet poster

Posts: 1

Excel Date Format Macro

Does anyone have or know where I can get a macro that will allow me to enter
a date for example as 112808 then "enter" and have excel format it as
11/28/08? (using a MM/DD/YY format)

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
Fixing the date format in a macro or VBA	Geoff B	Excel Worksheet Functions	1	September 7th 09 11:00 AM
Format date macro	Dagonini	Excel Programming	3	January 9th 07 02:08 PM
Date Format Macro Problem	joecrabtree	Excel Programming	4	December 20th 06 02:58 PM
Excel 2000 date format cannot be set to Australian date format	Brian Jones	Excel Discussion (Misc queries)	1	March 30th 05 06:03 AM
Macro to format date	sw	Excel Programming	4	October 15th 03 01:23 PM

All times are GMT +1. The time now is 05:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us