Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date entry
Is there a way to enter just the numbers 032107 and have it display the date
03/21/07? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date entry
It's kind of complicated:
http://cpearson.com/excel/DateTimeEntry.htm Biff "excel-duh?" wrote in message ... Is there a way to enter just the numbers 032107 and have it display the date 03/21/07? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date entry
There is a free Excel addin that does this,
http://www.xldynamic.com/source/xld.QDEDownload.html -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "excel-duh?" wrote in message ... Is there a way to enter just the numbers 032107 and have it display the date 03/21/07? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date entry
To T. Valko and Bob Phillips. Thank you for your quick assistance. This newby
to Excel and this Discussion site appreciates the help offered by veterans like you. "T. Valko" wrote: It's kind of complicated: http://cpearson.com/excel/DateTimeEntry.htm Biff "excel-duh?" wrote in message ... Is there a way to enter just the numbers 032107 and have it display the date 03/21/07? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date entry | Excel Discussion (Misc queries) | |||
last entry of a particular date | Excel Discussion (Misc queries) | |||
Automatic Date Entry | Excel Worksheet Functions | |||
Date entry automatically | Excel Discussion (Misc queries) | |||
Date entry | Excel Discussion (Misc queries) |