I'm with you David.

Change the Regional settings for future and clean up existing dates with your
Text to Columns method.


Gord Dibben MS Excel MVP

On Sat, 17 Feb 2007 20:44:06 -0000, "David Biddulph"
wrote:

Obviously one or other of us is confused, Rich. My understanding was that
custom format can alter the way the date is displayed, but not alter the
date itself. If he is seeing 1-Feb-07 then your custom format of DD MMM YY
will change the display to 01 Feb 2007. The *format* won't change his date
to 2-Jan-07. We'll wait to see whether your suggestion works for the OP,
but I would doubt it.