P
Peo Sjoblom
Tools>options>edit and uncheck fixed decimal places
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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?
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?
B
BrianB
Possibly the column is not wide enough to show the whole number
E
excel-qs
Forget it....I found a space in the nameid field that was screwing u
the vlookup's...
the vlookup's...
A
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.
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.
G
Gord Dibben
Anon
Format the cells as Number with no decimal places. The Scientific Notation
should disappear.
Gord Dibben Excel MVP
Format the cells as Number with no decimal places. The Scientific Notation
should disappear.
Gord Dibben Excel MVP