scientific notation

Don't waste your time. The guy is either a troll or the most immature
person to visit a newsgroup. He'd probably walk into an AA meeting,
offering to buy a round for the group and when no one took him up
on his offer, start preaching that AA is a cult.

"JE McGimpsey"wrote
> You obviously don't have very much experience with other software. XL
> has bugs, but there are far more worthy candidates for your hyperbole.
>
> Take a look at "About custom number formats" in XL Help.
>
>
> In article <1118155818.587107.23160@z14g2000cwz.googlegroups.com>,
> "aaron.kempf@gmail.com" <aaron.kempf@gmail.com> wrote:
>
> > Excel doesnt work.
> >
> > I mean-- i have a column with mixed large numbers; and excel keeps on
> > rendering it as scientific notation.. i mean-- wtf is up with Excel; it
> > is like the most buggy program ever written

the formatting doesn't work as advertised.

how do i get rid of scientific notation in cells from excel?

i never want to see any scientific notation in another cell-- ever
again.

how do i import it into a database without having it cough?

it should all be easier-- it should all be more reliable.

and i just wish that MS would fix these bugs.. i mean.. use the
product-- get a newbie and watch them and make it more useable.

it doesn't work.. i've worked with hundreds of newbies before.. and im
just tired of apologizing for the bugginess of the software..

i just wish that things would work reliably.

<aaron.kempf@gmail.com> wrote...
>the formatting doesn't work as advertised.

Yes it does, but you don't seem to understand the specs.

>how do i get rid of scientific notation in cells from excel?
....

Set the number format to something other than Scientific *OR* General. If
you use the General number format, you'll get numbers in scientific notation
when columns aren't wide enough to display in normal format. This is no
different from many other numeric applications that use a 'general' format
by default to display floating point reals.

>how do i import it into a database without having it cough?

Again, set the number format correctly, and you shouldn't have a problem. If
you do in some database, then the problem is in the *DATABASE*, not Excel,
so further bitching & moaning in this newsgroup would be OT.

i dont believe that works correctly.

sorry.

i want microsoft to fix it.

<aaron.kempf@gmail.com> wrote
> i dont believe that works correctly.
>
> sorry.
>
> i want microsoft to fix it.

And I want to win the Lotto

yeah. well.. i'm not the one that is selling crappy software

<aaron.kempf@gmail.com> wrote...
>yeah. well.. i'm not the one that is selling crappy software

No, you're the one who refuses to accept how the software works and refuses
to understant that it works the same way nearly all numeric software does
when representing floating point numbers of arbitrary magnitude as text on
output when you the user haven't bothered to specify your desired number
format.

For some, ignorance is bliss. For you it's just a way of life.

<aaron.kempf@gmail.com> wrote...
>i dont believe that works correctly.

You can believe the world is flat, the universe is centered on the Earth,
you're not obtuse, and other demonstrably false propositions and it won't
make them true.

FORMAT CELLS CONTAINING NUMBERS TO ENSURE THEY DISPLAY THE WAY YOU WANT.
*YOUR* failure to do so is *YOUR* problem alone, and there's squat all
Microsoft needs to fix (other than perhaps offering to pay for you to have a
lobotomy and/or one-way transit to a deserted island in the Indian Ocean).

>i want microsoft to fix it.

What's to fix? This is *DOCUMENTED* functionality, *AND* it's familiar to
*ANYONE* who's used *ANY* spreadsheet under MS/PC-DOS or Windows. Also
familiar to anyone who's programmed in any scripting language including VBA
(e.g., enter the following statements in the VBE Immediate window

? (1234# * 5678#) ^ 9#

? (12# * 34#) ^ 5#

). Anyone who knows C's printf format strings knows the difference between
%e (scientific), %f ('normal') and %g ('general') floating point number
formats. It's also part of FORTRAN 95,

http://www.ncsa.uiuc.edu/UserInfo/Re...HTM#HDRH000062

That you don't understand this concept is obvious, but just because you're
unwilling or unable to grasp this doesn't mean there's anything for
Microsoft to fix.

And to repeat, if numeric data is being pulled into some DBMS in scientific
format, doesn't the DBMS provide facilities to format those numbers some
other way? Or are you saying the *DBMS* is importing numeric data in
scientific format as text? Either way, it ain't Excel causing the problem.

Whow

GO YOU, Harlan......

See what Aaron has got to say to THAT.
( :> ))
--
Greetings from New Zealand
Bill K

"Harlan Grove" <hrlngrv@aol.com> wrote in message
news:uqqF8WYbFHA.348@TK2MSFTNGP14.phx.gbl...
> <aaron.kempf@gmail.com> wrote...
>>i dont believe that works correctly.
>
> You can believe the world is flat, the universe is centered on the Earth,
> you're not obtuse, and other demonstrably false propositions and it won't
> make them true.
>
> FORMAT CELLS CONTAINING NUMBERS TO ENSURE THEY DISPLAY THE WAY YOU WANT.
> *YOUR* failure to do so is *YOUR* problem alone, and there's squat all
> Microsoft needs to fix (other than perhaps offering to pay for you to have
> a
> lobotomy and/or one-way transit to a deserted island in the Indian Ocean).
>
>>i want microsoft to fix it.
>
> What's to fix? This is *DOCUMENTED* functionality, *AND* it's familiar to
> *ANYONE* who's used *ANY* spreadsheet under MS/PC-DOS or Windows. Also
> familiar to anyone who's programmed in any scripting language including
> VBA
> (e.g., enter the following statements in the VBE Immediate window
>
> ? (1234# * 5678#) ^ 9#
>
> ? (12# * 34#) ^ 5#
>
> ). Anyone who knows C's printf format strings knows the difference between
> %e (scientific), %f ('normal') and %g ('general') floating point number
> formats. It's also part of FORTRAN 95,
>
> http://www.ncsa.uiuc.edu/UserInfo/Re...HTM#HDRH000062
>
> That you don't understand this concept is obvious, but just because you're
> unwilling or unable to grasp this doesn't mean there's anything for
> Microsoft to fix.
>
> And to repeat, if numeric data is being pulled into some DBMS in
> scientific
> format, doesn't the DBMS provide facilities to format those numbers some
> other way? Or are you saying the *DBMS* is importing numeric data in
> scientific format as text? Either way, it ain't Excel causing the problem.
>
>

Why chance reigniting a thread like this?