using VBA in Excel it changes the dot of a number to a comma
You state that in some other computers it did not work fine. Does this mean
that it also produced the 4,56 in the other computers or that the macro would
not run in other computers? If it produces the same results in other
computers, then the problem would be somewhere in the macro code. If it
simply will not run in other computers, it could still be the code. If it
does run properly in the computers that it works in (i.e. produces 4.5) and
your computer is the only one producing 4,5 then the problem is likely in
your computer settings. Happy hunting.
"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
|