ExcelBanter - Date format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date format (https://www.excelbanter.com/excel-discussion-misc-queries/103679-date-format.html)

connie

Date format

I want to be able to input a date, 010206, and have it print: 01/02/06. How
can I do that?

Biff

Date format

Maybe this:

http://cpearson.com/excel/DateTimeEntry.htm

Biff

"Connie" wrote in message
...
I want to be able to input a date, 010206, and have it print: 01/02/06.
How
can I do that?

All times are GMT +1. The time now is 02:21 PM.