| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recognizing 2-digit years
Today I found to my consternation that my broker's updated web pages have changed the format of the CSV files I download daily. I have to re-work some complex formulas. On my way to accomplishing that, I find one change is that what had been four-digit years are now two-digit years. My Excel 2002 under XP isn't recognizing them as dates. Is there an easy fix here? Thanks, Dallman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I Calculate Check Digit for UPC A - the 13th warrior | Excel Discussion (Misc queries) | |||
| Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
| I need a formula to help me calculate years of vesting for 401K. | Excel Worksheet Functions | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| In Excel, how can you format for 4 digit years (MM/DD/YYYY)? | Excel Discussion (Misc queries) | |||
Threaded Mode
