View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LO in Sweden LO in Sweden is offline
external usenet poster
 
Posts: 4
Default Format cells to show dates as the day of the week

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