Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi and help. I've got a csv file with lots of lovely information in it including many a date field. In the csv the date is in the format mm/dd/yyyy (or if there's a leading zero m/dd/yyyy or mm/d/yyyy or m/d/yyyy), my problem is that when I bring this in to excel it will recognise all of the dates with a day of below 13 in the format dd/mm/yyyy and the other dates just go in as text. I can easily use a few text forumlea to reverse the day and month on the ones recognised as text and these can happily be used as the correct date but for the other dates they are taken as the wrong date and I can't figure out a way or getting these back to being correct. Any ideas? -- andyiain ------------------------------------------------------------------------ andyiain's Profile: http://www.excelforum.com/member.php...fo&userid=8335 View this thread: http://www.excelforum.com/showthread...hreadid=511071 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would rename the .csv file to .txt
then open that .txt file You'll be able to specify the format for each field--including the date fields. If you have to do this lots, you could record a macro when you do it once manually and then just rerun that macro when you needed to import the .txt file (important that the file is not named .csv.) andyiain wrote: Hi and help. I've got a csv file with lots of lovely information in it including many a date field. In the csv the date is in the format mm/dd/yyyy (or if there's a leading zero m/dd/yyyy or mm/d/yyyy or m/d/yyyy), my problem is that when I bring this in to excel it will recognise all of the dates with a day of below 13 in the format dd/mm/yyyy and the other dates just go in as text. I can easily use a few text forumlea to reverse the day and month on the ones recognised as text and these can happily be used as the correct date but for the other dates they are taken as the wrong date and I can't figure out a way or getting these back to being correct. Any ideas? -- andyiain ------------------------------------------------------------------------ andyiain's Profile: http://www.excelforum.com/member.php...fo&userid=8335 View this thread: http://www.excelforum.com/showthread...hreadid=511071 -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() That's got it. Thanks for your help there. Cheers Andy. -- andyiain ------------------------------------------------------------------------ andyiain's Profile: http://www.excelforum.com/member.php...fo&userid=8335 View this thread: http://www.excelforum.com/showthread...hreadid=511071 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Format problem | Excel Discussion (Misc queries) | |||
How do I stop a general format from being autoformatted to date | New Users to Excel | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
How to change date as general "200306" to date "06/2003" | Excel Discussion (Misc queries) |