Learn how to format numbers in Thousands, Millions, and Billions in Excel and Google Sheets. Use number Formatting to convert numbers.

Learn how to format & display Currency in Excel to display numbers as monetary values, by applying Currency or Accounting number format to cells.

Set the column data format to "General," and then click the "Destination" icon to specify in which cells the numbers should appear, or use the defaults.

Have you ever opened a spreadsheet and felt overwhelmed by a sea of unformatted numbers, struggling to make sense of the data? Whether it’s a financial report, survey results, or a project timeline, ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

In my post on table formatting, I demonstrated how to transform your static data into a simple yet sexy database in a matter of seconds. If you don’t know how to use table formatting, go read that ...

Color Numbers Based on Their Values Custom number format in Excel lets you define the color of the text in selected cells according to their values. What's more, for the main eight colors (black ...

Open an Excel spreadsheet and select the range of cells into which you'd like to add large numbers. Right-click one of the cells and click "Format Cells" to open the Format Cells dialog window.

Combine an Excel custom format with data validation and remove the pressure for input perfection from personnel by letting Excel do the work.

Excel's conditional formatting lets you customize how your data displays, from changing colors and shading to adding icons and more. Here's how it works.

Numbers ‘08, the new spreadsheet application in iWork ‘08, brings some powerful new tools to the table. As noted in my Numbers review, the ability to place multiple grids anywhere on a page, and mix ...