Your number is so large that Excel can only display it in scientific
notation. To see the entire number as entered enter an apostrophe as the
first character and follow that with your number. Excel will treat the entry
as a text entry and not as a numeric one.
Change the format from General to Number. With the cell selected, click
Format >> Cells. On the Number tab, change the category to Number. Set the
number of decimal places, whether or not to show commas, then click OK. Widen
the column enough to show the whole value.
You're right, my bad. BAKERSMAN, please ignore my earlier reply and refer to
Kevin's.
Ask a Question
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.