Numbers not registering in cell

5 pts.
Tags:
Microsoft Excel
Microsoft Excel spreadsheet
I am trying to enter data (money totals) in an existing spreadsheet but when I enter the numbers and go to the next cell, no numbers but ##### instead.
ASKED: June 15, 2012  6:21 PM
UPDATED: June 16, 2012  3:37 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Enlarge the size of your cell.
You data may be to large to display in the current size

This may also happen in a cell type mismatch. Right-click on the affected cell(s) and select Format cell. Select the appropriate data type (number or currency) plus the number of decimal points you want to see.

To shortcut the resize process, select the column by clicking the column letter. Now, double-click the right-hand divider between cells. This will auto-fit the cell size to the cell contents.

The above resize trick works with a range of columns. Select all the columns you want resized and double-click any of the column dividers.

Another problem you may face is exactly as you describe. The solution, however, is to click on a little triangle on a top corner of the cell. Look out for it; I don’t recall what causes it but floating your pointer over the triangle and/or the cell should clue you in.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Amgarner
    [...] ShawnHenricks clarifies how to expand the cell in an Excel spreadsheet for the numbers to [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following