Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I am sorry if this is a stupid question but here goes .
If I type in dates as 010106 it gives me 01/09/27 This was raised in an earlier Question I tried the reply by Ragdyer which was (If you were going to enter a *very* large number of dates into a column, where you might consider it worthwhile using several *extra* steps in Text To Columns (TTC), you could enter your dates using *6* digits (to avoid ambiguity), *without* delimiters. This entails a whole other procedure, so the saving wouldn't be realized unless the number of dates to be entered was quite large. For example, you could enter dates as mmddyy. 041705 121504 010105 101206 092504 122505 Then, select the cells, and <Data <TextToColumns <Next <Next Click on "Date", and make sure "MDY" shows in the window, Then <Finish. You've now made your 6 digit date entries recognizable to XL as *the* dates that you want, not "morphed" into dates XL chooses.) It did not work for me can someone please help me |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pre-1900 dates | Excel Discussion (Misc queries) | |||
Charts/ Graphs and Dates Trouble | Charts and Charting in Excel | |||
Need to pull current dates from list w/many dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Help with automatic dates | New Users to Excel |