Formatting in Cells
The Format Cells command controls the display characteristics of numbers and text. It is important to keep in mind the difference between underlying and displayed worksheet values. Formats do not affect the underlying numeric or text values in cells. For example, if you type a number with six decimal places into a cell that is formatted with two decimal places, the number is displayed with only two decimal places. However, the underlying value isn't changed, and Excel uses the underlying value in calculations.
Format before you copy
When you copy a cell, you copy both its contents and its formatting. If you then paste this information into another cell, the formatting of the source cell replaces any pre-existing formatting. To ...