Currency Settings

[Shailesh]

I have created a report using VBA and Excel OLAP cube. Some of the
metrics on the report are currency numbers and are to be reported in
USD so I have formatted them accordingly using format ( e.g. "$
#,##0.00"). Some of the users in Germany who use decimal (.) as
separator between numbers are not able to see the format correctly. I
hope they use comma in place of decimal and decimal in place of
commas
as we normally do. Also other users in Europe see Pound or Euro sign
instead of dollar. My report is being used in many geographies and I
have to use $ which every body should be able to see.

Any suggestions?

 

[Bernard Liengme]

The book "Excel 2002 VBA" by Stephen Bullen et. al. has a chapter called
International Issues. I expect their newer books also have this.
Hope this is of some help to you