Multi language issue

[Nick]

I have set up a spreadsheet for use in New Zealand and
Germany. For most text I have a dictionary page with
alternative text depending on the user choice of language.
I use the offset formula to select the relevant text and
this works well. However, I have an issue with number
formatting: Is there a way to easily change the number
style for thousands from 1,000 (which is my NZ default) to
1.000 which is used in Germany ?
(Any other tips on multi language modelling would also be
appreciated). Thanks very much

 

[Jan Karel Pieterse]

Hi,

The number format shown in Cells will depend on the users
settings (control panel, regional settings). What happens
to numbers you show using VBA depends on how and what you
wish to show.

Application.International may give you information on the
users XL and Win language settings. Check OLH for more
information.

If you use the VBA Format function to show numbers as
string, it will show them according to the regional
settings.

There are many other issues involved, excellently
explained in this book:

Excel 2000/2002 VBA Programmers Reference. Stephen
Bullen, John Green, Rob Bovey, Robert Rosenberg. Wrox
Press.


Regards,

Jan Karel Pieterse
Excel TA/MVP