Date format in the cell
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. |
Date format in the cell
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 --------------- Jacob Skaria "backmara" wrote: 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. |
All times are GMT +1. The time now is 12:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com