That is a number, equal to 1.00311 with the decimal point moved to the
right by 14 places. You can format it as a fixed point number if you
wish by selecting it's cell and clicking on Format>Cells. Then tell it
to use "number" format rather than "scientific". It will probably just
show you a bunch of ##### which means that your column isn't wide enough
to display so large a number.
Generally speaking, if you have such a large number it's easier to
understand it with scientific notation than with fixed point.
What is the number supposed to be? That is the real question. In my
experience, it looks like a date. Do as Bill Martin wrote and format as a
date, if it supposed to be date.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
