Date format in the cell

[backmara]

How I can change date format.
My problem is following: I use other program where I can export excel-file.
This program use USA format (like 05/25/2009), but my excel use europe
format (like 25.09.2009).Queston is, how I can change my excel's cells (or
worksheet) setting. I don't wanna change my computer settings, only cell or
worksheet settings.

Final results: I must calculate date, so now excel not work.

 

[Jacob Skaria]

Try this....
Select the column.
From menu..Data-->Text to Columns..Next..Next will bring you to the Wizard
Step 3 of 3. Then select Date option button and select the format MDY. Hit
Finish..

If this post helps click Yes