Date formatting
Apologies because i've posted a couple on here regarding this problem.
Bascially i export information from a system. The dates in excel end up as both text and number formats. Format 30-03-2006 is text, 10/04/2006 is number. No matter what i do i cannot convert the test data into the number format. Tried right clicking and changing it. Copying and pasting special values etc. The reason i need to change it is because i then import the info into a access db, which i then want to manipulate by deducting the date i have exported from today. Any ideas (Sorry for the long winded explanation but its quite a complex problem) |
Date formatting
You're probably set up with an American date format and importing
European-style dates. Try highlighting the column and choosing data text to columns next next date:DMYFinish. Hawksby wrote: Apologies because i've posted a couple on here regarding this problem. Bascially i export information from a system. The dates in excel end up as both text and number formats. Format 30-03-2006 is text, 10/04/2006 is number. No matter what i do i cannot convert the test data into the number format. Tried right clicking and changing it. Copying and pasting special values etc. The reason i need to change it is because i then import the info into a access db, which i then want to manipulate by deducting the date i have exported from today. Any ideas (Sorry for the long winded explanation but its quite a complex problem) |
Date formatting
Brilliant thank you v much
"Lori" wrote: You're probably set up with an American date format and importing European-style dates. Try highlighting the column and choosing data text to columns next next date:DMYFinish. Hawksby wrote: Apologies because i've posted a couple on here regarding this problem. Bascially i export information from a system. The dates in excel end up as both text and number formats. Format 30-03-2006 is text, 10/04/2006 is number. No matter what i do i cannot convert the test data into the number format. Tried right clicking and changing it. Copying and pasting special values etc. The reason i need to change it is because i then import the info into a access db, which i then want to manipulate by deducting the date i have exported from today. Any ideas (Sorry for the long winded explanation but its quite a complex problem) |
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com