Day and language fomat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

A1:= "monday" and not "Monday"
By formatting the A1 Cell: Format/Cell/number/custom:dddd

First: This displays "lundi" instead of "Lundi"
Second: How about if I would like "Monday" in English and not in French, in
other words: "Monday" and not "Lundi".

Thanks very much for helping me
Tom
 
Hi Tom

Try, in B1,
=TEXT(A1,"[$-409]dddd")
works in newer Excel versions only.

HTH. Best wishes Harald
 

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 in other languages 2
Remove redundant spanish language date info from the header area? 4
Excel Find and Replace Problem with Array 1
How do I test if the weekday is between Monday and Friday ? 5
Subtract day and time w/o weekends or holidays 2
Using SUMPRODUCT Function on Calculated (Function-Derived) Data 6
Mention the Day NOT the date please 1
first day of the current month 5

Back
Top