| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format in cell | Excel Discussion (Misc queries) | |||
| How can I get date of file creation to XLS cell in date format? | Excel Worksheet Functions | |||
| How do I format a cell to a date format? | Excel Discussion (Misc queries) | |||
| Date format does not appear in cell | Excel Discussion (Misc queries) | |||
| cell format for date/time in same cell excel 2003 | Excel Worksheet Functions | |||
Linear Mode
