O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required