ExcelBanter - Change date format

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Change date format (https://www.excelbanter.com/new-users-excel/74888-change-date-format.html)

Åsa I

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

Gary''s Student

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

All times are GMT +1. The time now is 11:26 PM.