"General" cell format nixes numbers

[Peo Sjoblom]

Tools>options>edit and uncheck fixed decimal places

 

[Anon]

This is a really simple problem, but I can't seem to figure it out.

I have cells formatted as the "general" type. If I type in something like
19, then the cell displays ".19". If I type something in like 123456798,
then the cell displays "12345678.8". Sometimes with really long numbers it
will display something like "123456798+11".

It's happening in all of excel, no matter what workbook is open. It also
happens on all computers I log into, so it's probably an excel setting
somewhere in my profile.

How I do I display standard numbers again?

 

[BrianB]

Possibly the column is not wide enough to show the whole number

 

[excel-qs]

Forget it....I found a space in the nameid field that was screwing u
the vlookup's...

 

[Anon]

Thanks for the decimal place idea. That fixed the decimal issues. I missed
that option like 3 times.

However, super long numbers like 123456789123 still turn into 1.234567E+11,
no matter what the column width is.

Any ideas? Thanks for the replies so far.

 

[Gord Dibben]

Anon

Format the cells as Number with no decimal places. The Scientific Notation
should disappear.

Gord Dibben Excel MVP