Posted to microsoft.public.excel.programming

Bill[_30_] Bill[_30_] is offline

external usenet poster

Posts: 89

European vs English Issue

Hello,
I want to find the number of values in a database greater than a certain
value UL. The following code works in the United States Regional Option:

If UL < "" Then NumOOS = Application.CountIf(Database, "" & UL & "")

But it always gives 0 in, for example, the regional option for Germany.

Any ideas why?

Thanks,

Bill

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Using english and non-English Excel commands simultaneously in anon-English installation	Michael.Tarnowski	Excel Worksheet Functions	6	March 12th 10 07:21 AM
Translate any english number into English word	SANTANU	Excel Discussion (Misc queries)	2	March 4th 10 04:42 PM
how do I convert English (Canadian) dates to English (US) dates	dinertx	Excel Worksheet Functions	1	July 11th 08 03:59 PM
European date formats	lynniemilano	Excel Worksheet Functions	1	September 13th 05 05:47 PM
Issue with European Versions and VBA	Bill[_30_]	Excel Programming	1	February 25th 05 02:25 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us