Microsoft Excel question

[Orrex]

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?"

[democracyindanger]

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.

[Orrex]

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!

[LynneSin]

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

[Orrex]

4. Good point

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