Dear,

When I use a field in format number the decimal point is not recognised. My
system setting for numbers tell me that a komma "," is the decimal
seperator. I like to keep it that way because I use it in HTML.
I've got a keyboard with a point in de numeric region. When I use a komma
"," it works, but it's not quit easy.

Changing the number format (format as decimal) is not a solution.

can someone help me!

tom <toml@pandora.be> wrote:

> When I use a field in format number the decimal point is not recognised. My
> system setting for numbers tell me that a komma "," is the decimal
> seperator. I like to keep it that way because I use it in HTML.
> I've got a keyboard with a point in de numeric region. When I use a komma
> "," it works, but it's not quit easy.

As far as I know you have to choose either the point or the comma as
decimal separator, not both. You may enter numbers with decimal points
into a text entry field and define your number field as a calc
Substitute (text entry, ".", ",")

-- 
Hans Rijnbout
Utrecht, Netherlands

Hans Rijnbout wrote:
> tom <toml@pandora.be> wrote:
>>When I use a field in format number the decimal point is not recognised. My
>>system setting for numbers tell me that a komma "," is the decimal
>>seperator. I like to keep it that way because I use it in HTML.
>>I've got a keyboard with a point in de numeric region. When I use a komma
>>"," it works, but it's not quit easy.
> As far as I know you have to choose either the point or the comma as
> decimal separator, not both. You may enter numbers with decimal points
> into a text entry field and define your number field as a calc
> Substitute (text entry, ".", ",")

How about using a 'space'?
-- 
MARCH FOR WOMEN'S LIVES: April 25th, 2004 [ http://march.feminist.org/ ]
The students of the University of Southern California are fundraising to send USC 
feminists to D.C.
Please donate what you can to help us attend the conference/march via PAYPAL, under the 
jamesony@usc.edu account. Folks who donate and send an email will get a photo and journal 
of our time there. Thanks.

~consul <consul@INVALIDdolphins-cove.com> wrote:

> Hans Rijnbout wrote:
> > tom <toml@pandora.be> wrote:
> >>When I use a field in format number the decimal point is not recognised. My
> >>system setting for numbers tell me that a komma "," is the decimal
> >>seperator. I like to keep it that way because I use it in HTML.
> >>I've got a keyboard with a point in de numeric region. When I use a komma
> >>"," it works, but it's not quit easy.
> > As far as I know you have to choose either the point or the comma as
> > decimal separator, not both. You may enter numbers with decimal points
> > into a text entry field and define your number field as a calc
> > Substitute (text entry, ".", ",")
> 
> How about using a 'space'?

That would work as well, substituting a comma for the space in the
number calculation. But you should be wary of users typing leading or
trailing spaces into text entry fields. You can remove these with the
Trim function.


-- 
Hans Rijnbout
Utrecht, Netherlands