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

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

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

These new functions empower users to dynamically extract relevant information, remove unwanted characters, and format text with unparalleled efficiency. The new REGEX functions in Excel offer a ...

Leading zeros are those pesky place-holding 0 digits at the beginning of a number. Unfortunately, when you enter such a value, Excel applies the General numeric format and tosses out the leading zero.

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.