Hi Alex
though this works this has one drawback: It's not in the same cell :-)
If this is o.k. for the OP then he may use a formula solution 8less
overhead).

BTW a shorter formula to achieve this would be:
=--TEXT(A1,"00-00-00")

--
Regards
Frank Kabel
Frankfurt, Germany
"Alex" schrieb im Newsbeitrag
...
Frank Kabel

Check out my post. I found a way of solving the date problem in Excel. See
what you think. It is a bit clumsy but as a one-off it works ok.

Alex

"Frank Kabel" wrote:

Hi
you'll need VBA for this. You may try the following addin to just achieve
this:
http://www.xldynamic.com/source/xld.QDEDownload.html

--
Regards
Frank Kabel
Frankfurt, Germany
"Legal Learning" schrieb im
Newsbeitrag ...
I want to enter my date like this: 010105 abd have it format it like
this:
January 1, 2005. Help!
--
CLG