LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I place a comma after each number in a column corinnecarter Excel Discussion (Misc queries) 1 January 8th 10 06:14 PM
Inserting comma(,) after every two digits of a number from right t Senapati Excel Worksheet Functions 2 October 28th 09 11:55 AM
Extract name before comma, space & number SherryScrapDog Excel Discussion (Misc queries) 3 January 26th 09 02:46 AM
how i can show only the constant number after the comma yasser Excel Discussion (Misc queries) 9 July 30th 07 11:29 PM
HOW DO I PUT 'COMMA' IN NUMBER, AS I WISH Meena Setting up and Configuration of Excel 1 February 23rd 07 04:33 PM


All times are GMT +1. The time now is 04:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"