Re: Excell can't add

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 03/01/04


Date: Sun, 29 Feb 2004 17:37:11 -0700

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"

In article <uYdpWex$DHA.2808@TK2MSFTNGP10.phx.gbl>,
 "Norman Harker" <njharker@optusnet.com.au> wrote:

> US NIST has adopted the use of a space for digit spacing:
>
> http://physics.nist.gov/cuu/Units/checklist.html
>
> A space or half-high dot is used to signify the multiplication of
> units.
>
> It's silent on use of decimal sign but uses a dot throughout.
>
>
> Chances of a decimal dot being dropped approach 0!



Relevant Pages

  • Re: Pen in show mode
    ... Yes the pen and felt tip marker "dot" in show mode is terrible. ... "Luc" wrote: ... >> In 2003 in the show mode the pen or the felt tip marker cursor is only a ...
    (microsoft.public.powerpoint)
  • Re: Self-measuring P.D.s
    ... > Have a Sharpie or other permanent marker in hand. ... > Bring tip of marker toward lens so that the object is obscured and dot ... > Measure the distance from dot to dot across the front of the frame. ...
    (sci.med.vision)
  • glob behaviour changed in 8.4, documented?
    ... non-Unix-system when it comes to files starting with a dot: ... I did not find anything in the ChangeLog* in tcl 8.5.2). ... I would have expected a "POTENTIAL INCOMPATIBLITY" marker in the ...
    (comp.lang.tcl)
  • Re: Lock first column and title row in Excel sheet by code
    ... In this case the chance my program is affecting a user is very small. ... My program creates the new workbook at 6:00 in the morning, ... the specific property you are trying to work with uses the active cell as its marker for setting the new "home" position of the resulting scrollable area. ...
    (microsoft.public.vb.general.discussion)