ExcelBanter - Format date to put in / or -

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

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

- - Format date to put in / or - (https://www.excelbanter.com/excel-discussion-misc-queries/45637-format-date-put.html)

DKR

Format date to put in / or -

Can you format a cell so that you can just put in 091505 and it will enter it
as 09/15/05. Sure would save me some time.

Chip Pearson

You can't do it with formatting. You need VBA code. See
http://www.cpearson.com/excel/datetimeentry.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"DKR" wrote in message
...
Can you format a cell so that you can just put in 091505 and it
will enter it
as 09/15/05. Sure would save me some time.

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