Dear Experts,

We have developed an application in VB6. This application exports some
results to Excel. The Excel displays error "The number in this cell is
formatted as text or preceded by an apostrophe". An exclamation sign
appears with the cell offers "Convert to Number" option. We have
controlled all this through PasteSpecial VBA code within our
application.

xlBook.ActiveSheet.Range("Z7").Copy
xlBook.ActiveSheet.Range("A1:X10").PasteSpecial Paste:=xlPasteValues,
Operation:=xlAdd, SkipBlanks:=False, Transpose:=False

This code work fine if we use dot (.) as decimal separator. However for
another locale setting where comma (,) is used as a decimal separator,
the above block of code does not convert the values intu number (in
Excel). Can anyone help me out.

Any help will be highly appreciated.

Thanks & Regards,

Faiz