The Cyber-Spy.Com Usenet Archive Feeds Directly
From The Open And Publicly Available Newsgroup
This Group And Thousands Of Others Are Available
On Most IS NNTP News Servers On Port 119.
Cyber-Spy.Com Is NOT Responsible For Any Topic,
Opinions Or Content Posted To This Or Any Other
Newsgroup. This Web Archive Of The Newsgroup And
Posts Are For Informational Purposes Only.
From: "red rover"
Subject: Re: Forcing Excel Into Engineering Notation ??
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
Date: Thu, 5 Sep 2002 21:25:14 -0400
NNTP-Posting-Date: Thu, 05 Sep 2002 21:20:08 EDT
Organization: Bell Sympatico
I believe the hash mark means the digit is only used if required and the
zero means it is mandatory. By using it as ##0 you are forcing
it to to increment the exponent every 10^3.
1 to 999 then
1E3 to 999E3 .....
Jim Thompson wrote in message
>On Tue, 03 Sep 2002 09:35:16 -0700,
>Jim Weir ,
>In Newsgroup: sci.electronics.design,
>Entitled: "Re: Forcing Excel Into Engineering Notation ??",
>Wrote the following:
>|shared these priceless pearls of wisdom:
>|->Make sure you enter the cell *custom* format as... ##0.0E+0
>|->I just double-checked it from 1u to 100k.
>|And I've been trying for the last hour again this morning to make it just
>|exactly like that. Hmmm....I'm trying it on an already programmed
>|albeit in an unused cell. I wonder what would happen on a virgin sheet?
>|Lemme get it straight...three hashmarks (###) followed (no spaces) by zero
>|zero (0.0) followed (no spaces) by capital E to the plus zero (E+0).
>|Did I get the form correct?
>TWO hash marks! EXACTLY... ##0.0E+0
>The NET THREE spaces is what makes the "3 exponent" rollover.
>My Format pulldown (Excel 97) already contained examples of this.
> ...Jim Thompson
>| James E.Thompson, P.E. | mens |
>| Analog Innovations, Inc. | et |
>| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
>| Phoenix, Arizona Voice:(480)460-2350 | |
>| Jim-T@analog_innovations.com Fax:(480)460-2142 | Brass Rat |
>| http://www.analog-innovations.com | 1962 |
> For proper E-mail replies SWAP "-" and "_"
>I love to cook with wine. Sometimes I even put it in the food.
Go Back To The Cyber-Spy.Com
Usenet Web Archive Index Of
The sci.electronics.design Newsgroup