answersLogoWhite

0

When the cell is not wide enough to display the numbers that are in it. Widening the column will enable you to see the numbers properly.

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

What does it mean when the contents of a cell turns to pound signs in excel?

The number in the cell is too long to be displayed in the cell. Increase the column width to display the entire number.


Meaning of the '' sign in Excel?

When you see a cell full of number signs (#########) it means the cell is not wide enough to display all the content in that cell. Make the column wider to display all the content of the cell. If you like, you can click on the letter at the top of the column and select column auto width to ensure all cells are wide enough to display their contents.


When number signs () are displayed in the cell it means?

When number signs (###) are displayed in a cell in spreadsheet applications like Excel, it typically indicates that the cell is not wide enough to display the full content, usually a number or date. To resolve this, you can widen the column by dragging the boundary on the right side of the column header or by double-clicking it to auto-fit the width. This will allow the full value to be visible.


In Microsoft Excel sometimes I type a lot and it replaces my text with a bunch of number signs how do I get rid of that?

If the contents of a cell are too big to display within that cell Excel will use empty cells to the right to display it in full. However, if adjacent cells aren't empty Excel will display ##### to indicate that the column is not wide enough to display the contents. Make the column wider by dragging the right hand border of the column header to the right. If you double click instead of dragging the column will re-size itself to accommodate the longest entry.


What is a number that can be entered into a cell on Excel?

Which of the following is a number that can be entered into a cell?


Why do random entries in Excel get replaced with the number symbol?

The number symbol (#) indicates that the content of the cell is wider than the cell can display. Increase the column width and you will see the cell contents, instead of ##########.


Where does excel display the data as you enter it?

in the cell and in the formula bar


In Excel what can be assigned to a cell that will display a calculated result?

formula


A specific way in which Excel display numbers in a cell is referred to as the?

Format.


Describe the division function in Excel?

If you want Excel to divide one number by another, use the "/" character. For example, if I want to divide 4 by 2 this is what I would enter in a cell: =4/2 Excel will display the result of the division. In this case, 2. You can also divide using cell references. Lets say cell A1 contains the number 4 and A2 contains the number 2. Enter the following in the cell where you want the result: =A1/A2 Again, Excel will display the result (2) in the cell where you entered the formula.


How do you display a symbol in front of a field result in excel?

You can display the currency symbol in front of a result in a cell by formatting the cell for currency. When you format the cell, you can choose the currency symbol you want to display.


How many words can you fit in one Microsoft Excel cell?

It depends on the length of each word. The number of words does not matter; the limit is the number of total characters, including spaces. The maximum length of cell contents (text) is 32,767 characters. Only 1,024 display can display in a cell, but all 32,767 characters display in the formula bar.