Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day and language fomat
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day and language fomat
See this site: http://support.microsoft.com/kb/177561/
"Tom" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day and language fomat
Hi Tom
Try, in B1, =TEXT(A1,"[$-409]dddd") works in newer Excel versions only. HTH. Best wishes Harald "Tom" skrev i melding ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fomat Cell | Excel Discussion (Misc queries) | |||
How to change German language data into Eglish Language in a colum | Excel Discussion (Misc queries) | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
Time Fomat | Excel Worksheet Functions | |||
How to change the excel format from language to language? | Excel Discussion (Misc queries) |