Home |
Search |
Today's Posts |
#1
|
|||
|
|||
On an import to excel a two digit date still is not right after c.
On my companies host system we store dates with only two digit years and we
use pivot dates to interpret correctly. When I create an extract of these dates and import into excel they are not interpreted as the correct century. I have already changed the regional settings to accomodate this and when I just key a date into excel cell such as 12/1/30 it comes back correctly as 12/1/2030. However, the same date in my import will come out as 12/1/1930. I think it has something to do with the import but I am not sure what. Thanks for any suggestions. -- PCastle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
How can I import a text file into excel with each field as a sepe. | Excel Discussion (Misc queries) | |||
Excel Date Format - Stop? | Excel Worksheet Functions | |||
Excel 2002 date formulas problem | Excel Worksheet Functions |