Excel converting dates to numbers.
 

Hi,

I am facing a peculiar problem. I sent one of the Excel files to one of my
friend which contained some dates (dd-mm-yyyy format) but when he opened the
file the dates were converted to text (mm/dd/yyyy format). I had done some
calculations on the basis of the dates and now they are returning #N/A. I do
not have a clue to what has happened.

Any ideas?

Best Regards,

Vikas

Excel converting dates to numbers.
 

Try formatting the cells with dates in them in an unambiguous format:
mmmm dd, yyyy
(for instance)

Then check to see if the dates match in both workbooks.
01/02/2007
(could mean January 02, 2007 or February 01, 2007)

There could be a discrepancy between the "real" dates that you're sharing.

But I've only seen this problem when I'm sharing text files (.txt or .csv or
..prn). Never with .xls files.
If you're sharing text files (like .csv), you could rename that file to .txt and
then use File|Open to open the text file and choose the correct date format for
each field.


Vikas Chandelia wrote:

Hi,

I am facing a peculiar problem. I sent one of the Excel files to one of my
friend which contained some dates (dd-mm-yyyy format) but when he opened the
file the dates were converted to text (mm/dd/yyyy format). I had done some
calculations on the basis of the dates and now they are returning #N/A. I do
not have a clue to what has happened.

Any ideas?

Best Regards,

Vikas

--

Dave Peterson