Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Date for Sorting | Excel Discussion (Misc queries) | |||
Date formatting help | Excel Discussion (Misc queries) | |||
Can a date be used for conditional formatting? | Excel Worksheet Functions | |||
Conditional Formatting, date. | Excel Worksheet Functions | |||
Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) |