Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel date problem
Name: kytaipan Date: March 14, 2007 at 12:30:02 Pacific OS: Windows XP CPU/Ram: Intel VPro Product: HP
Comment:
HELP! I have a column of dates imported into Excel from a txt file. The dates appear as 12035 for January 20th 2035, but when I use the 'Text to Column' feature to format the dates it gives me the result of 01/20/1935!! Is there a way around this old Y2K problem???
Name: Jennifer SUMN Date: March 14, 2007 at 14:29:35 Pacific
Reply:
That is to be expected. Any 2 digit number between 00 and 29 is interpreted as 2000 - 2029. Numbers between 30 and 99 are interpreted as 1930, etc.
You'll need to either create a macro or use vlookup formulas to change the years, or, correct the text file to show 4 digits for the year, and then import the data back into Excel.
Summary: Hi there, Excel doens't support negative dates, meaning when you substract today's date from yesterday's date , it will give an error. don't have a clue what you are making, so if i had some more info...
Summary: Very interesting problem. I think hair pulling is in order. It seems that the 1904 date system is tied to the workbook. Can you convert the 1904 workbook to 1900 values and then update the linked shee...
Summary: If your Excel formatting is indeed turning 34.5% into .00345, then you do have a problem. 34.5% in decimal format is .345. If you change the format of a cell that contains a number, it will indeed ch...
0 
