On Wed, 9 Feb 2011, Dmitrii Dimandt wrote:
When I convert this file to a text format, I get this:

01/10/10   40,452

the 10th of January 2010 is about 40,450 days from 1st of January 1900, which is how all excel dates actually get stored internally.... If you take a date cell and reformat it as a number, that's what you'll see

What I suspect is happening is that you don't have the right format applied to your formula cells. Can you double check they're really set to format as a date?

Nick

Reply via email to