View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vikas Chandelia Vikas Chandelia is offline
external usenet poster
 
Posts: 5
Default 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