The Format Painter in Excel lets you copy formatting from one cell or group of cells to another cell or group of cells without copying their contents. Cell formatting includes everything from font ...

The text with the desired style (font, size, etc.) is highlighted and Format Painter (paint brush icon) is clicked. Whichever text is highlighted next is then changed to the desired style.

Use the Format Painter tool to copy the Currency or Accounting number format to other cells. Now that you know how to format financial figures correctly in Microsoft Excel, why not use the program ...