0
No. Rounding can be one way of formatting, but generally they are very different. Rounding just changes the amounts of decimal places displayed. Formatting can do that and a huge amount of other things, such as the type of number, like currency or percentage. Formatting can change the size, the font and the colour. Formatting can change underling, italics and bolding. So it can change a lot of things. Rounding is just one specific thing you can do.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
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.
If you have finished formatting a chart and now need to create a new chart that uses the same formatting for inclusion in a presentation How can you use this efficiently in Excel 2007?
Use format painter
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.
Does rounding up mean the same thing as estimate?
An estimate is an educated guess based on prior knowledge. Rounding off is knowing the exact value but rounding it to the nearest whole number.
What is the difference between Excel sheet and spread sheet?
They are the same thing, excel is Microsoft's spreadsheet programme.
Excel questionWhen you apply a style to text any conflicting formatting in the cell is replaced by the style format?
Any conflicting formatting will be replaced by the style that is being applied. Whatever formatting that may have already been applied to the cell that is different to the style will be set to be the same as the style.
How long does a cell remain formatted in Excel?
It will stay formatted until the formatting is changed to something else, so it can in effect have the same format permanently if it is not changed.
How does estimating using only the first digit in the greatest place compare with rounding to the greatest place?
it's the Same thing
Is estimating the same as rounding off and why?
No, it is not. Estimating may be rounding but need not be.
When you are rounding a number and the number you are rounding to is the same number do you keep the number that you are rounding the same?
Yes. 12300 rounded to the nearest hundreds is 12300. No problem!
What formatting does a newly inserted row contain?
The same formatting as the cells above of them
How are estimating and rounding the same?
They are not.
