CLG

This can be done in Excel. It is a little 'messy' but here we go.

Enter your dates in column A. Just type them as numbers no matter how they
appear. For example,

010105 will appear as 10105
260105 will appear as 260105

Now in Cell B1 cut and paste the following formula:

=VALUE(IF(LEN(A1)=5,"0"&LEFT(A1,1)&"/"&MID(A1,2,2)&"/"&RIGHT(A1,2),LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,2)))

This will turn your cell values into a number format that Excel recognises
as a date.

Now highlight all the cells in column B and right click the mouse and
select...

<Format Cells... and select <Custom in the 'category' box.

In the space under 'Type:' add the following....

mmmm d, yyyy

This will convert all your dates to how you want them.

Now select column B and select <copy. Then select cell A1 and select <Paste
special and select <Values.

Now column A will have your dates just as you like them.

This process is not ideal when working with dates but it saves using VBA!

If you have any problems then please do not hesitate to contact me. I will
endeavour to assist further.

Regards


Alex




"Legal Learning" wrote:

I want to enter my date like this: 010105 abd have it format it like this:
January 1, 2005. Help!
--
CLG