| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
European date formats
I received an Excel spreadsheet from an Italian colleague but the formulas
aren't working properly because although I can input dates in dd-mm-yy format they are displayed in mm-dd-yy format even when I choose the Italian format from the menu, i.e. October 10th is saved as 03-10-05 but is displayed as 10-03-05. Anyone have any ideas how I can fix this? thanks, Lynn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formats | Excel Discussion (Misc queries) | |||
| Reading Date Formats e.g 20050801 (yyyy/mm/dd) | Excel Discussion (Misc queries) | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| excel date formats changed | Excel Worksheet Functions | |||
| Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
Threaded Mode
