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.
Date changes when copied
Name: Jonathan Date: November 27, 2003 at 13:17:21 Pacific OS: NT CPU/Ram: 128
Comment:
I've got an excel file where all the dates were changed. The cell format is "Date (14-mar-98)". Funny thing, if I try to copy a cell on another worksheet in another workbook with the same cell format, the data will change. Les say you have 01-Dec-03, it'll change to 30-Nov-99 in the new workbook!
Ok, if you follow me, here is another one. You know that if you change a "date" cell format into "general"... the data inside that cell will give you a number (try it if you've never done it). So 01-Dec-03 on the corrupt file gives 36494 when the cell format is changed to "general". If its changed back to the "date" format, I'll get back 01-Ded-03. If I do the same excercice on the new workbook with the copied date (30-Nov-99)...it'll give me 36494, change it back to "date" format, and it gives 30-Nov-99.
Do you have an explanation before I throw my computer out the window!
Summary: When I copy formulas, they are not updated as they are supposed to, ie. when copying a formula like =A1 from B1 to B2, the new formula in B2 becomes =A1 and not =A2 as it's supposed to when not using ...
Summary: We are GOING CRAZY! We have a column of dates in a HUGE Excel file, and when we copy of paste, paste special, values, Excel is automatically changing the year of the dates. HOW DO I GET EXCEL TO STO...
Summary: I'm sending mailing lists to our a house every month containing the addresses of our international readers. However, recently I have had a problem with the column which contains the zip code/post c...
Excel problem
