Microsoft Excel question - Democratic Underground

Orrex

(1000+ posts) Send PM | Profile | Ignore

Wed Jan-17-07 03:15 PM
Original message

Microsoft Excel question

How the hell do I turn off the automatic scientific notation formatting? I can say categorically that I will never need this function in my line of work, yet a sizable amount of numbers with which I work are automatically chewed up and spit out in 1.23E+106 format, and it's a major pain in the ass.

Suggestions?

Suggestions that don't involve an answer along the lines of "Get a Mac?"

Printer Friendly | Permalink | | Top

democracyindanger

(1000+ posts) Send PM | Profile | Ignore

Wed Jan-17-07 03:18 PM
Response to Original message

1. Format cells

Not sure of the specific command name, but select all (ctrl+a), format cells and then select the numerical notation format.

You could probably set it up as a default style, but I can't offer a step-by-step for that.

Printer Friendly | Permalink | | Top

Orrex

(1000+ posts) Send PM | Profile | Ignore

Wed Jan-17-07 03:23 PM
Response to Reply #1

3. Thanks!

I've been using the Format Cells option, but I really want to figure out how to make it my default.

Thanks for the input, though!

Printer Friendly | Permalink | | Top

LynneSin

(1000+ posts) Send PM | Profile | Ignore

Wed Jan-17-07 03:21 PM
Response to Original message

2. Also make sure you've given enough space for the cell number

I work with Giga & Terabytes in some of my work and if the column width is too small for some of these numbers they'll truncated into Scientific Notation.

Usually I widen the column and then change the number to regular numbers through the Format Cell process

Printer Friendly | Permalink | | Top

Orrex

(1000+ posts) Send PM | Profile | Ignore

Wed Jan-17-07 03:23 PM
Response to Reply #2

4. Good point

Sometimes I get a string of pound-signs when the columns are too narrow, too.

Printer Friendly | Permalink | | Top

DU AdBot (1000+ posts)

Fri May 03rd 2024, 07:03 AM
Response to Original message

Advertisements [?]

Top

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators

Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.