Subject: Re: Forcing Excel Into Engineering Notation ??
Summary: You know, it's really been a long, long time...
Sender: Tut AmongUs
X-Newsreader: Forte Agent 1.91/32.564
Date: Wed, 04 Sep 2002 02:04:19 GMT
NNTP-Posting-Date: Tue, 03 Sep 2002 22:04:19 EDT
On Tue, 03 Sep 2002 14:04:38 GMT, Al Clark
>Jim Thompson wrote in
>> On Mon, 02 Sep 2002 17:46:59 -0700,
>> Jim Weir ,
>> In Newsgroup: sci.electronics.design,
>> Article: ,
>> Entitled: "Re: Forcing Excel Into Engineering Notation ??",
>> Wrote the following:
>>|->Did you actually try it? It worked for me in Excel 2000.
>>|Yes, I did try it, and I tried it in almost every permutation I could
>>|think of for about an hour this morning. I'll try it again. I am also
>>|running Excel 2K. It seems Jim Thompson tried it also and it worked, so
>>|I've got some homework to do.
>> Make sure you enter the cell *custom* format as... ##0.0E+0
>> I just double-checked it from 1u to 100k.
>> ...Jim Thompson
>Okay you Excel hotshots, can you solve this formatting problem:
>In Excel if you want to display hexadecimal numbers you can use a function
>DEC2HEX. If the number is positive it will display an arbitrary number of
>characters as specified by the function call. Is there anyway to display a
>fixed number of places when the result is negative?
IIRC, there are no negative hex numbers. Positive whole numbers
If you want per answer handling, you really want a database engine
like Paradox or such that allows the view of the data to be parsed and
managed without changing the data itself.