Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format cells
I have been trying to type the dates with this format mm/dd/yyyy, but I would
like not to do it everytime I want to insert a different date. I just want to type the numbers, and that excel put the date format automaticaly without me typing the // or formating it each time a put a different date. |
#2
|
|||
|
|||
Chip Pearson has some techniques that convert your input to dates at:
http://www.cpearson.com/excel/DateTimeEntry.htm Helen wrote: I have been trying to type the dates with this format mm/dd/yyyy, but I would like not to do it everytime I want to insert a different date. I just want to type the numbers, and that excel put the date format automaticaly without me typing the // or formating it each time a put a different date. -- Dave Peterson |
#3
|
|||
|
|||
Helen
Excel needs to see a separator when you are entering dates. Couple of ways around this. 1. Enter the dates like 123105 or 42805 then go to DataText to ColumnsNextNextColumn Data FormatDateMDYFinish. Your dates will now be dates. 2. Use VBA code to change the entered data to dates as you enter them without a separator. http://www.cpearson.com/excel/DateTimeEntry.htm Gord Dibben Excel MVP On Sat, 8 Oct 2005 09:08:03 -0700, "Helen" wrote: I have been trying to type the dates with this format mm/dd/yyyy, but I would like not to do it everytime I want to insert a different date. I just want to type the numbers, and that excel put the date format automaticaly without me typing the // or formating it each time a put a different date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
How do I get brackets in format cells accounting? | Excel Discussion (Misc queries) |