MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Valid date format in cell

Posted by tee on January 21, 2002 5:53 PM

Hi Everyone

How can I have the user enter a date in a certian format in a cell.

If they enter a date like 01/01/02 - excel will automately transform it to 01 - Jan - 02.


Posted by Barrie Davidson on January 21, 2002 5:57 PM

Tee, just change the cell's formatting (if I understand your question). Select Format|Cells and use the Date category to select what you want.

Hope this helps you out.
BarrieBarrie Davidson

Posted by tee on January 21, 2002 7:13 PM

Many thanks - I did not think of that. Too easy.