Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello!
I need week in English now I got Swedish I do this! Format cells to show dates as the day of the week Select the cells that contain dates that you want to show as the days of the week. On the Home tab, in the Number group, click the arrow, click More Number Formats, and then click the Number tab. Under Category, click Custom, and in the Type box, type dddd for the full name of the day of the week (Monday, Tuesday, and so on), or ddd for the abbreviated name of the day of the week (Mon, Tue, Wed, and so on). BUT I ONY GET MÅ, TI, ON, TO, FR, LÖ, SÖ My Regional and language Option - Standards and forms is Swedish! I must have Swedish so I cant change to get Mon, Tue, Wed, and so on. Dose some one have a wokeround? Best regards LO in Sweden |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format cells to show part of a postcode? | Excel Worksheet Functions | |||
show in text format the difference between 2 dates | Excel Discussion (Misc queries) | |||
Format Cells to show different values | Excel Worksheet Functions | |||
How to format cells to show dates as the week-ending date of that | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions |