Date as text

[Dylan&Hayden]

Hello everyone,

I am trying to get this to work but I can't seem to find a solution:

I have a date in cell A1 in this case it is currently
1/1/2009 and I need it to read: 010109

Using the following formula I can most of the way there

Please Login or Register  to view this content.

The formula above gets 1109 and I need 010109

Thanks!

[NBVC]

Try:

=TEXT(A1,"mmddyy")

[solnajeff]

Hi

For all relevant cells go to Format/Cells/Custom and enter mmddyy.

Regards

Jeff

[Dylan&Hayden]

Why do I always over think these things.

Thanks for the help!