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
|