From: Jim Thompson
Subject: Re: Forcing Excel Into Engineering Notation ??
X-Newsreader: Forte Agent 1.91/32.564
Organization: EasyNews, UseNet made Easy! - Test our service with our FREE trial at https://www.easynews.com/trial/trial.phtml
X-Complaints-Info: Please be sure to forward a copy of ALL headers otherwise we will be unable to process your complaint properly.
Date: Tue, 03 Sep 2002 16:44:20 GMT
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 spreadsheet,
|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 point
|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.
| 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.