ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   . and , while working with User Forms (https://www.excelbanter.com/excel-programming/392814-while-working-user-forms.html)

Avishai

. and , while working with User Forms
 
I have a Text Box in a User Form that gets a number from a cell. Whenever I
re-open the excel file, and the number is not X.0 (such as 1.1, 1.2, 1.3 and
on...) then it appears in the Text Box as X,0 Instead of X.0
In order to fix the problem I go to the 'regional and language
configurations' and re-select the '.' (which is allready selected)
The problem continues when I change the seperators configuration in the
Excel option as whell.
How do i avoid configurating the '.' as the seperator every time i open the
file?
thanx,
Avishai


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com