LinkBack URL
About LinkBacks
When you say it worked Sept 06 - Dec 06, is this now another workbook? Have you made a copy?
When you say it worked Sept 06 - Dec 06, is this now another workbook? Have you made a copy?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Yes and no, I noticed in the original sheet that the date function stopped working as of 01-01-2007. So I created an exact duplicate and entered the same formula into the sheet.
Something is really weird here, I just went back to the original sheet and made a new entry, when I do this, I get a date value of 10-Jan-
07.
Yesterday this was not possible. The formula and option settings in this original exactly match the one I zipped in this forum. So how can one work and not the other? I attached a working copy of this sheet. password is set to: temp
Thought this what is was, you have a macro that does the FixedDate function. You can see it by right-clicking on the xl icon to the left of File, it's under Module 1, you need to copy this to your new workbook
You found it! Thanks for all your help, I would not have fixed this without you.
Glad your OK now - thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks