| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing date formats
hello everybody
I have thousands of rows looking like this: 20060505 20070302 20050708 etc. How can I change these to date formats so I can calculate the number of days between these dates and another row of dates? Any ideas? regards Heine |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing date formats
One way:
Select a column of dates to be converted. Choose Data/Text to Columns. Click Next, Next, then select YMD from the Date dropdown. Click finish. Repeat for any other columns of dates. In article .com, Heine wrote: hello everybody I have thousands of rows looking like this: 20060505 20070302 20050708 etc. How can I change these to date formats so I can calculate the number of days between these dates and another row of dates? Any ideas? regards Heine |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing date formats
On May 3, 2:53 pm, JE McGimpsey wrote:
One way: Select a column of dates to be converted. Choose Data/Text to Columns. Click Next, Next, then select YMD from the Date dropdown. Click finish. Repeat for any other columns of dates. In article .com, Heine wrote: hello everybody I have thousands of rows looking like this: 20060505 20070302 20050708 etc. How can I change these to date formats so I can calculate the number of days between these dates and another row of dates? Any ideas? regards Heine- Hide quoted text - - Show quoted text - It works great - thanks a lot -- Heine |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing date formats
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
or =--(TEXT(A1,"0000\/00\/00")) -- David Biddulph "Heine" wrote in message oups.com... hello everybody I have thousands of rows looking like this: 20060505 20070302 20050708 etc. How can I change these to date formats so I can calculate the number of days between these dates and another row of dates? Any ideas? regards Heine |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
changing date formats
"David Biddulph" wrote: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) or =--(TEXT(A1,"0000\/00\/00")) -- David Biddulph "Heine" wrote in message oups.com... hello everybody I have thousands of rows looking like this: 20060505 20070302 20050708 etc. How can I change these to date formats so I can calculate the number of days between these dates and another row of dates? Any ideas? regards Heine excellent H S SHASTRI INDIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The Cell formats keep changing itself from text to date | Excel Discussion (Misc queries) | |||
| Changing date formats? | Excel Discussion (Misc queries) | |||
| Changing Imported Date Formats | Excel Worksheet Functions | |||
| Changing Imported Date Formats | Excel Worksheet Functions | |||
| Excel 2003 is changing my date formats | Excel Worksheet Functions | |||
Hybrid Mode
