Hi,

Foolproof way just like :
tval = replace("4,6",",",".")

but doesn't change your comp setting
--

Regards,

Halim


"abygorb" wrote:

Hi, when I program on VBA in Excel to show in a dialog (text box or other) a
number from a cell (ex 4.56) it changes the dot for a comma (I will see in
the dialog 4,56) and this doesn't happend viceversa. I run this macro in
other computers and in some of them it worked fine and in others it didnt. I
explained this problem in a VBA forum and they couldn't fine the answer. (all
the regional configuration in windows and in excel is configured correctly
"." for decimal and "," to separate thousands). I think the problem its a non
compatibility issue between a Office and Windows (XP) version

Any help will be appreciated

abygorb