Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting in different countries
I've recently created a spreadsheet which contains a date formatted to show
as the day of the week by means of "dddd". However this spreadsheet is to be used in Germany and France and I've discovered that in order for the formatting to work, "dddd" has to be replaced with "tttt" in Germany (for Tag) and "jjjj" in France (jour). I'm quite surprised by this as I though that the formatting would have been taken care of in Excel regardless of the country it was being opened. Is this a problem anyone else has encountered and how did you get around it? Libby |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting in different countries
I might be mistaken, but wouldn't the regional settings translate that
appropriately? Does this help? http://www.oaltd.co.uk/ExcelProgRef/Ch22/ --JP On May 10, 4:01 am, Libby wrote: I've recently created a spreadsheet which contains a date formatted to show as the day of the week by means of "dddd". However this spreadsheet is to be used in Germany and France and I've discovered that in order for the formatting to work, "dddd" has to be replaced with "tttt" in Germany (for Tag) and "jjjj" in France (jour). I'm quite surprised by this as I though that the formatting would have been taken care of in Excel regardless of the country it was being opened. Is this a problem anyone else has encountered and how did you get around it? Libby |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting in different countries
You'd have thought so, but apparently not. A spreadsheet with a date
formatted with a formula as text to "dddd" displays "dddd" in Germany unless the dddd in the formula is changed to tttt. "JP" wrote: I might be mistaken, but wouldn't the regional settings translate that appropriately? Does this help? http://www.oaltd.co.uk/ExcelProgRef/Ch22/ --JP On May 10, 4:01 am, Libby wrote: I've recently created a spreadsheet which contains a date formatted to show as the day of the week by means of "dddd". However this spreadsheet is to be used in Germany and France and I've discovered that in order for the formatting to work, "dddd" has to be replaced with "tttt" in Germany (for Tag) and "jjjj" in France (jour). I'm quite surprised by this as I though that the formatting would have been taken care of in Excel regardless of the country it was being opened. Is this a problem anyone else has encountered and how did you get around it? Libby |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting in different countries
Libby,
The way I do it is as follows: - first, create a cell with my preferred date format, let's say Z1 on sheet Control (it can be a hidden sheet) - add a defined name (InsertNameDefine...) of say myDateFormat, and a RefersTo value of =GET.CELL(7,Control!$Z$1) and then in your spreadsheet use =TEXT(NOW(),myDateFormat) To be really flexible, you could create a number of cells with different formats, all with different defined names, and use appropriately. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Libby" wrote in message ... You'd have thought so, but apparently not. A spreadsheet with a date formatted with a formula as text to "dddd" displays "dddd" in Germany unless the dddd in the formula is changed to tttt. "JP" wrote: I might be mistaken, but wouldn't the regional settings translate that appropriately? Does this help? http://www.oaltd.co.uk/ExcelProgRef/Ch22/ --JP On May 10, 4:01 am, Libby wrote: I've recently created a spreadsheet which contains a date formatted to show as the day of the week by means of "dddd". However this spreadsheet is to be used in Germany and France and I've discovered that in order for the formatting to work, "dddd" has to be replaced with "tttt" in Germany (for Tag) and "jjjj" in France (jour). I'm quite surprised by this as I though that the formatting would have been taken care of in Excel regardless of the country it was being opened. Is this a problem anyone else has encountered and how did you get around it? Libby |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting in different countries
I posted a version of this in your previous thread dealing with this
question (but I'm guessing you haven't checked back there yet)... Try this variation (the "aaaa" returns the day name with the localized spelling for the computer it is being run on)... =TEXT(<<YourDate,"aaaa") Also, instead of "aaaa", you can use "aaa" for the localized abbreviated day name. You can also use these patterns when Custom Formatting a Cell. Rick "Libby" wrote in message ... You'd have thought so, but apparently not. A spreadsheet with a date formatted with a formula as text to "dddd" displays "dddd" in Germany unless the dddd in the formula is changed to tttt. "JP" wrote: I might be mistaken, but wouldn't the regional settings translate that appropriately? Does this help? http://www.oaltd.co.uk/ExcelProgRef/Ch22/ --JP On May 10, 4:01 am, Libby wrote: I've recently created a spreadsheet which contains a date formatted to show as the day of the week by means of "dddd". However this spreadsheet is to be used in Germany and France and I've discovered that in order for the formatting to work, "dddd" has to be replaced with "tttt" in Germany (for Tag) and "jjjj" in France (jour). I'm quite surprised by this as I though that the formatting would have been taken care of in Excel regardless of the country it was being opened. Is this a problem anyone else has encountered and how did you get around it? Libby |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting in different countries
Just to follow up on this issue... Harlan Grove has raised a question about
how this would work in French Excel since that version uses "a" for its year patterns. Any French Excel users out there who can test it out for us? Rick "Rick Rothstein (MVP - VB)" wrote in message ... I posted a version of this in your previous thread dealing with this question (but I'm guessing you haven't checked back there yet)... Try this variation (the "aaaa" returns the day name with the localized spelling for the computer it is being run on)... =TEXT(<<YourDate,"aaaa") Also, instead of "aaaa", you can use "aaa" for the localized abbreviated day name. You can also use these patterns when Custom Formatting a Cell. Rick "Libby" wrote in message ... You'd have thought so, but apparently not. A spreadsheet with a date formatted with a formula as text to "dddd" displays "dddd" in Germany unless the dddd in the formula is changed to tttt. "JP" wrote: I might be mistaken, but wouldn't the regional settings translate that appropriately? Does this help? http://www.oaltd.co.uk/ExcelProgRef/Ch22/ --JP On May 10, 4:01 am, Libby wrote: I've recently created a spreadsheet which contains a date formatted to show as the day of the week by means of "dddd". However this spreadsheet is to be used in Germany and France and I've discovered that in order for the formatting to work, "dddd" has to be replaced with "tttt" in Germany (for Tag) and "jjjj" in France (jour). I'm quite surprised by this as I though that the formatting would have been taken care of in Excel regardless of the country it was being opened. Is this a problem anyone else has encountered and how did you get around it? Libby |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems using Excel from different countries | Excel Discussion (Misc queries) | |||
Counting 22 countries in one formula | Excel Discussion (Misc queries) | |||
Using Excel in different countries | Excel Worksheet Functions | |||
world countries | Excel Discussion (Misc queries) | |||
something having kids altogather from different countries | Excel Discussion (Misc queries) |