| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change date format
Hi,
I have tried to change a norweigian date format into swedish without luck. Any suggestions? Current date format 20.01.06 Would like to have 2006-01-20 Ã…sa |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Change date format
If you enter 20 January 2006 in a cell and format it as dd.mm.yy you will see
20.01.06 If you format as yyyy-mm-dd you will see 2006-01-20 -- Gary's Student "Ã…sa I" wrote: Hi, I have tried to change a norweigian date format into swedish without luck. Any suggestions? Current date format 20.01.06 Would like to have 2006-01-20 Ã…sa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Format Problems?? | Excel Discussion (Misc queries) | |||
| MS Query Date Format | Excel Discussion (Misc queries) | |||
| I cannot change the date format to English canada | Excel Discussion (Misc queries) | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| change date function format in footer | Excel Worksheet Functions | |||
Linear Mode
