LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 49
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The Cell formats keep changing itself from text to date Hervinder Excel Discussion (Misc queries) 2 November 16th 06 03:56 PM
Changing date formats? lakegoddess Excel Discussion (Misc queries) 5 January 6th 06 05:26 PM
Changing Imported Date Formats Craig Lloyd Excel Worksheet Functions 5 December 20th 05 02:30 PM
Changing Imported Date Formats Craig Lloyd Excel Worksheet Functions 0 December 20th 05 12:51 PM
Excel 2003 is changing my date formats nbalch Excel Worksheet Functions 4 January 26th 05 07:01 PM


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"