Multilingual features in Excel

S

SIS

I run MAC OS 10.3 and Office 2004 in English. However, I do have to
create Excel worksheets in German and would like Excel to show dates in
the German Date format, i.e. 1. Juli 2006. When I format a cell to
dd.mmmm.yyyy, Excel converts my input (01/07/06) to 1. July 2006, which
is not what I want. The Excel help gives the following information:
About multilingual features in Office
Microsoft Office 2004 programs support editing and viewing of documents
in many languages. If you work with documents that contain text in more
than one language, if you work in a multinational organization, or if
you share documents with people who use Office on systems that run in
other languages, you or your system administrator can customize Office
to manage conventions and requirements unique to each language.
Here are a few examples of ways you can use multilingual features:
· Correct date, time, and number style When you enter dates,
times, and numbers, the Office programs can format them in the correct
style for different languages.

but it does not tell me how to do it.

Can anybody help?
 
M

Mark Perka-MS

To enable the dates to behave as German dates should you need to use the OS
system preferences panel and
enable those formats for German that you want to use ...

1. Click System Preferences
2. Click the International Preference Panel
3. You can use the Format tab to pick German for the region which will give
you date formats you are looking for within the format number dialog.


I run MAC OS 10.3 and Office 2004 in English. However, I do have to
create Excel worksheets in German and would like Excel to show dates in
the German Date format, i.e. 1. Juli 2006. When I format a cell to
dd.mmmm.yyyy, Excel converts my input (01/07/06) to 1. July 2006, which
is not what I want. The Excel help gives the following information:
About multilingual features in Office
Microsoft Office 2004 programs support editing and viewing of documents
in many languages. If you work with documents that contain text in more
than one language, if you work in a multinational organization, or if
you share documents with people who use Office on systems that run in
other languages, you or your system administrator can customize Office
to manage conventions and requirements unique to each language.
Here are a few examples of ways you can use multilingual features:
· Correct date, time, and number style When you enter dates,
times, and numbers, the Office programs can format them in the correct
style for different languages.

but it does not tell me how to do it.

Can anybody help?
 

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

Top