0
Formatting won't change the actual data. It may change how it looks, so it appears to be different. For example if you reduce the amount of decimal places in a number, it may round the number up, so 3.46 could be displayed as 3.5, but it won't change the actual value. Even though you would now see 3.5 it will still contain 3.46 and use that in the calculations it is used in.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What affects the data in the cell on Microsoft Excel?
Formatting can change the look of a cell and its contents.
Does formatting a cell in Microsoft Excel alter its contents?
No. Only the formatting will change. The actual values will stay the same, even if a value appears to have rounded up, like if you reduced the amount of decimal places.
How do you remove table formatting in excel 2007?
Highlight the table range, go to cell formatting, and change the format to whatever you like.
Which Excel feature would allow you to change the font and color of a cell based on its value?
Conditional Formatting.
Is it true that Formatting can change the actual data of a cell?
No it will just change the appearance of a label, it does not alter the data.
If the value of the cell changes and no longer meets the specified condition does Excel suppress the conditional formatting?
The cell will no longer use the formatting that was appropriate before the change. The formatting option still exists so that if the cell is changed again, the formatting may be applied again, if the cell meets the particular conditions.
How do you change an Excel cell color using an IF statement?
You would not use an If statement to do it in a normal formula that is directly in a cell. You would do it through Conditional Formatting. Go to Conditional Formatting and you can enter an if formula instead of a cell value for determining the condition, and then set the formatting you want.
Each cell in a table contains a that you use to select and format cells?
This question makes no sense in the Microsoft Excel category. A cell contains cell formatting, you right-click and select cell formatting to change the formatting in a cell.
What is the excel feature by which a cell takes on the formatting of the number typed into the cell?
A number typed in a cell has no formatting of its own. Formatting is determined by the format set for the cell. You may be asking about conditional formatting, but it is difficult to tell from your question.
How can you make it so that dependent on what you type in an Excel cell the background colour changes for the cell?
You use Conditional Formatting. You can set up to 3 conditions to change the colours or other formatting for the cell. You will find it under the Format menu.
How do I retain Excel cell formatting during mail merge into a table in Word?
Merge brings one to several individual cells from Excel into Word. The formatting in the merged Word document depends on Word, not Excel. If you would like to retain the same formatting as you had in Excel, then format the target location in Word to match the cell from Excel.
Bold Italic and Underline are what in excel?
cell formatting options
