. and , while working with User Forms

=?Utf-8?B?QXZpc2hhaQ==?=

Guest

Posts: n/a

6th Jul 2007

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

« Coordinates of Cell | many types of loops »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 Forms (Not User Forms)	Lenny	Microsoft Word Document Management	1	11th Feb 2010 08:57 AM
Working with User Forms In Outlook	=?Utf-8?B?ZGNoMw==?=	Microsoft Outlook VBA Programming	1	13th Jun 2007 06:33 PM
multiple user working in the same mailbox, notsure who is working	=?Utf-8?B?bXV0aW5vdXM=?=	Microsoft Outlook Discussion	0	7th Feb 2007 07:44 PM
Which is more efficient and user-friendly: Using forms for the databases through Access or through forms created in VB?	A Future Computer Scientist	Microsoft Access	13	26th Sep 2003 11:41 AM
Number of admin user accounts and old user name still working	A Paranoid Newsgroup User	Windows XP Security	1	13th Jul 2003 02:45 AM