|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How do I enter a date without using slashes or dashes?
You can use a worksheet_change event that converts your text entry to the
date entry automatically. I did this for a client a few days ago.
--
Don Guillett
SalesAid Software
"Sue Miller" <Sue wrote in message
...
I want to be able to enter, for example, "030107" and have the cell
formatted
so I get 03/01/07.
|