Re: Formats, language, arrays, PROBLEMS!! Help please.

Article View: microsoft.public.excel.misc

Article #9

Back to microsoft.public.excel.misc Previous Next

From: Stephen Bullen
Date: Tue, 21 Oct 1997 00:00

20 lines
1421 bytes

Hi Mikael,

> Using an american modulestandard, but having to use a danish numberformat
> gives me a problem. I'm storing numbers from a set of inputboxes on a
> dialogsheet in an array, but when I type in the numbers in danish
> number standard, there's a problem.
>

I don't get any problems if I explicitly do the conversion from text to 
number using CDbl and Format:

 dVal = CDbl(oTB.Text)
 oTB.Text = Format(dVal, "#,##0.00")

 Regards

 Stephen Bullen
 Microsoft MVP - Excel
 http://ourworld.compuserve.com/homepages/Stephen_Bullen

Technical Details

Message-ID: <VA.0000019a.02a652a8@gateway.compuserve.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <01bcd978$f8c82360$0100007f@me>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fad30,173910ef62787cca
X-Google-Attributes: gidfad30,public
X-Google-Thread: f87f8,173910ef62787cca
X-Google-Attributes: gidf87f8,public
X-Google-Thread: fa6f6,173910ef62787cca
X-Google-Attributes: gidfa6f6,public
X-Google-Thread: 111b46,173910ef62787cca
X-Google-Attributes: gid111b46,public
X-Google-Thread: 10ad1d,173910ef62787cca
X-Google-Attributes: gid10ad1d,public
From: Stephen Bullen <104074.3411@compuserve.com>
Subject: Re: Formats, language, arrays, PROBLEMS!! Help please.
Date: 1997/10/21
Message-ID: <VA.0000019a.02a652a8@gateway.compuserve.com>
X-Deja-AN: 282318263
References: <01bcd978$f8c82360$0100007f@me>
Reply-To: 104074.3411@compuserve.com
Newsgroups: microsoft.public.excel.misc,dk.edb,dk.edb.programmering,microsoft.public.excel.programming,slac.users.excel

Reply to Parent Message