The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable …

Use the Format function in an expression You can use Format wherever you can use expressions. For example, you can use it in a query as part of a field alias, or in the Control …

Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. With format painter, you can copy all of the …

Use the Format Painter tool to copy one shape's fill and formatting to another with a few clicks. Note that Format Painter only copies visual formatting—it doesn't copy any data the shape …

The Numeric format switch (\#) specifies the display of a numeric result. For example, the switch \# $,0.00 in { = SUM (ABOVE) \# $,0.00 } displays a result such as "$4,455.70." If the result of …

In Word, you can choose to paste text using the formatting of the source, destination, or just pure text. If you always want one of the options, set it as the default for pasted text.

Training: Use Format Painter to quickly copy and apply formatting to text, shapes, and pictures.

Learn how to get started with this guide.

Format cells, numbers, text, and other data in Excel to improve readability. Learn how to apply borders, shading, text colors, and more.

Use the Format function in an expression You can use Format wherever you can use expressions. For example, you can use it in a query as part of a field alias, or in the Control …

Use Word on your tablet to select and format text, change line and paragraph spacing, change indentation, and add lists.