| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| Date format | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
Linear Mode
