Excel's format painter doesn't just work with cell formatting—you can also duplicate formatting between shapes, charts, text ...

Paste Special is an underrated tool in Microsoft Excel, with many people only using it to paste values. But it can do much ...

Excel's text formatting capabilities can make the results of your financial, statistical or scientific spreadsheet calculations more esthetically pleasing and easier to follow. You can use one of ...

Learn how to suppress or hide zero values in an Excel sheet using ... The @ is a text placeholder, similar to the 0 placeholder. Use this custom format to inhibit zero values in a specific range.

A CSV (comma-separated values ... column and change the kind of formatting for that data. When you're satisfied, click Finished. Quick tip: A CSV file is not an Excel file. While CSV files ...

Pro tip: Never change the format of a cell with a date to General or Text. Excel will turn your date into an unrelated number. For example, 3/3/2017 becomes 42797 when it's not formatted as a date.