Board index » Excel » Excel converting dates to numbers.

Excel86
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


-

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:

--



Dave Peterson

-