Hi
could you post your macro. In general which should no be an issue as
also for the german version VBA uses the dot as decimal separator

--
Regards
Frank Kabel
Frankfurt, Germany

"JT" schrieb im Newsbeitrag
...
I have a macro that is used by people in the US and in
Germany. The macro adds columns to check total debits vs.
total credits.

When I run it in the US, it works fine because it sees
50.25. But when the macro runs for one of the German
users, it sees 50,25 and it doesn't use the 25 in
calculating the total.

I can identify whether or not the user is from Germany in
the spreadsheet and I'm looking for some code or
suggestions on how to have the macro add up the German
numbers 50,25?

Thanks for the help.