Currency Settings

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
Wed May 07 09:36:15 CDT 2008

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Shailesh" <shailesh.tewari@gmail.com> wrote in message
news:9bc3632d-a377-420e-a4e0-059f666fd6b2@m44g2000hsc.googlegroups.com...
>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?
>
>