Re: Excell can't add

From: Norman Harker (njharker_at_optusnet.com.au)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 17:49:03 +1100

Hi JE!

Thanks for the reference on that one.

Re the ISO position. The quote I was was:

"In accordance with an ISO Council decision, the decimal sign is a
comma in all ISO documents." ISO 31-0:1992

Now whether that just applies to ISO documents or is a standard, I'm
not so sure. I think it's a Standard where you are in an ISO
compliance situation.

I'll have to get a copy of this Standard some time. (Unfortunately,
you have to pay!) 

-- 
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-B9701F.17371129022004@msnews.microsoft.com...
> Actually, NIST is quite specific:
>
>     http://physics.nist.gov/Pubs/SP811/sec10.html
>     10.5.2 Decimal sign or marker
>     The recommended decimal sign or marker for use in the United
States
>     is the dot on the line [4, 8]. For numbers less than one, a zero
is
>     written before the decimal marker. For example, 0.25 s is the
>     correct form, not .25 s.
>
> (Fer cryin out loud, they're *physicists*! They wouldn't leave
something
> like that to chance - it might lead to, say, miscalculating a
trajectory
> to Mars or somethin'!)
>
> > Chances of a decimal dot being dropped approach 0!
>
>     "approach" == "are indistinguishable from"