Change date format

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date 2
Change default format in 2007 4
Date format clarification 6
how to change format of several dates entered in an Excel column 2
Arbitrary change of spell check language 3
Access Running Balance in Access 1
Change format DATE language 2
Date-error Format 7

Top