Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default Issue with European Versions and VBA

Hello,
I have a small program that associates have been trying to use in Germany.
Part of it is a text box where they enter a number (like 1.5, 20, etc.) The
decimals don't work right. They have tried chaning their settings, etc.

Any ideas?

Thanks.

Bill


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Issue with European Versions and VBA

I suspect they are entering 1,5 for 1.5. If so, you would need something
like

Dim sStr as String
Dim dblNum as Double
sStr = Textbox1.Text
dblNum = cDbl(sStr)

cDbl will convert it to a double and will respect their regional settings.

--
Regards,
Tom Ogilvy

"Bill" wrote in message
hlink.net...
Hello,
I have a small program that associates have been trying to use in Germany.
Part of it is a text box where they enter a number (like 1.5, 20, etc.)

The
decimals don't work right. They have tried chaning their settings, etc.

Any ideas?

Thanks.

Bill




Reply
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
Excel Spreadsheet View Issue XP and 2003 versions iains Excel Discussion (Misc queries) 8 July 30th 09 10:11 PM
European Address Data John.Greenan Excel Discussion (Misc queries) 0 May 11th 07 08:42 AM
Please include fonts from previous versions ('98) in new versions JJBQ Excel Discussion (Misc queries) 3 October 8th 05 07:19 PM
European date formats lynniemilano Excel Worksheet Functions 1 September 13th 05 05:47 PM
Enter european date Pat Excel Programming 0 April 5th 04 03:31 PM


All times are GMT +1. The time now is 07:05 AM.

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

About Us

"It's about Microsoft Excel"