0
In excel How do you format a cell with no data to show a blank instead of 0?
Wiki User
∙ 12y ago
It is not done for individual cells. You can change a setting in the options to not show a 0 where a formula results in one.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Format cell in Excel?
To format a cell in excel right click on it, then on the thing that pops up click on format cell
What is cell of the excel?
To format a cell in excel right click on it, then on the thing that pops up click on format cell
What cell in excel with a numerical value of zero?
Blank Cell
Is there a way to see all formatting in an Excel document?
You can see the formatting in the displayed cells, because that is the purpose for formatting. However, if the cell is blank, you need to look at each cell to determine its format.
When you type numbers in a format that excel recognizes excel automatically applies format to the cell true or false?
False
In excel what contains the numerical value of zero?
Blank Cell.
How do you conceal data in excel?
It depends on what you are trying to accomplish. You can hide a column, so it does not appear or you can format the cell contents to be white instead of black.
How do you fix the dollar sign to the left of the column every time you enter an amount in excel?
I do not understand the question, but if you are asking, how to put a dollar sign in a cell and have it always align to the left side of the cell, then you format the cell as accounting instead of currency.
The underline format will underline . in excel?
only the characters in the cell
The underline format will underline in excel?
only the characters in the cell
What will the underline format underline in excel?
only the characters in the cell
What does CTRL plus 1 do in excel?
It lets you format the cell
