| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter a date without using slashes or dashes?
I want to be able to enter, for example, "030107" and have the cell formatted
so I get 03/01/07. |
|
#2
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a date without using slashes or dashes?
Look he
http://xldynamic.com/source/xld.QDEDownload.html -- Kind regards, Niek Otten Microsoft MVP - Excel "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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a date without using slashes or dashes?
Hi Don,
Quite possible. But I don't know if the OP knows how to implement that, and this utility requires no knowledge of VBA. -- Kind regards, Niek Otten Microsoft MVP - Excel "Don Guillett" wrote in message ... | Niek, | | Wouldn't a worksheet_change event involve less overhead? | | -- | Don Guillett | SalesAid Software | | "Niek Otten" wrote in message | ... | Look he | | http://xldynamic.com/source/xld.QDEDownload.html | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "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. | | | | |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a date without using slashes or dashes?
Sue
You cannot format for this. See Chip Pearson's site for quick date entry. http://www.cpearson.com/excel/DateTimeEntry.htm Gord Dibben MS Excel MVP On Thu, 1 Mar 2007 06:10:30 -0800, Sue Miller <Sue wrote: I want to be able to enter, for example, "030107" and have the cell formatted so I get 03/01/07. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a yyyymmdd date format with no dashes | Excel Discussion (Misc queries) | |||
| date entry without typing dashes | Excel Discussion (Misc queries) | |||
| how to put date slashes in to a column of number | Excel Discussion (Misc queries) | |||
| how do i enter a date quickly without using slashes or dashes? | Excel Discussion (Misc queries) | |||
| In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
Hybrid Mode
