Posted to microsoft.public.excel.programming

joecrabtree joecrabtree is offline

external usenet poster

Posts: 111

Date Format Macro Problem

To all,

I have a worksheet where column A is a series of dates. These dates can
be in the format 2006/10/02 yyyy.dd.mm or 10/02/2006 dd.mm.yyyy. etc. I
want to be able to change them all so that they equal the dd.mm.yyyy
format. Is there anyway to do this using VBA, and not the cell format
options, which do not seem to work anyway.

Thanks in advance for your help,

regards

Joseph Crabtree

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
Date Format Problem	Alain	Excel Discussion (Misc queries)	2	May 31st 10 04:53 PM
Excel Format Problem - Date Overrides Format	Mary	Excel Discussion (Misc queries)	5	February 10th 10 05:49 AM
date format problem using Macro	mohavv	Excel Discussion (Misc queries)	1	October 15th 08 01:09 AM
Date Format Problem	Suzanne	Excel Discussion (Misc queries)	2	February 20th 08 03:05 PM
Date format Problem Macro	joecrabtree	Excel Programming	1	December 18th 06 09:51 AM

All times are GMT +1. The time now is 12:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us