I had similar problem with storing very long numbers in excel. I solved it by putting a single quote (') in front of the number. This way it was able to display the number properly and could also take this number in account in formulas and computations. Perhaps this trick could work on dates too. try putting '01 Jan 2012 in the excel and see if excel could recognize it as date.
Sadly, I don't have excel on this computer otherwise i would have tried it before posting.
Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.
Last Visit: 31-Dec-99 18:00 Last Update: 19-Apr-14 11:19