LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default using VBA in Excel it changes the dot of a number to a comma

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 02:44 PM.

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"