Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
French format
Hello,
I have the need to have 2 cells side-by-side (one in English and the other in French). In the English one, I have =Text('variables'!$B$33,"dddd mmm dd, yyyy") which results in the value 'Saturday, September 01, 2007' being returned. How can I do the same but resulting in the French counterpart being returned such as 'Samedi le 1 septembre, 2007'? Is there a way to set the language of a cell? Thank you for your guidance, Daniel P |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bad french characters | Excel Discussion (Misc queries) | |||
bad french characters | Excel Discussion (Misc queries) | |||
How do I format numbers for French-style in Excel v.X for mac? | Excel Discussion (Misc queries) | |||
TEXT function to format a date in English & French | Excel Worksheet Functions | |||
Importing French (Canadian) format html pages | Setting up and Configuration of Excel |