MAil merge problem with amounts with spanish regional settings

Hi everyone...

thanks for stopping by at this thread. I appreciate your kind suggestions.

I have a piece of code that does mail merge automaticall using Excel as the source of data. In US format everything was working fine but when I changed my regional settings to Spanish(Spain) I ran into problem. The amounts in US currecy were showing as 1,234,567.12 which was correct and the same need to be displayed as 1.234.567,12 (In spanish setting comma is interchanged with period)

Just to add.. when I manuall perform the mail merge from the word template, everything was fine...

Please find me a way

SK
New York