Excel Forum
Similar Content
Format Cells in The Short Date Number Format in Excel
Macro: This free Excel macro applies the Short Date number format to a selection of cells in Exce...
How to Create and Manage a Chart in Excel
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...
Round Numbers Up or Down in Excel
Tutorial: How to round a number up or down and also to a specified number of decimal places in Excel...

Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Number

See how to use Go To Special Blanks to highlight all cells with Blanks. Then use Ctrl + Enter to put the same number in all cells. Then with the cells still highlighted apply Custom Number format to show an asterisk before each number.

Got a Question? Ask it Here in the Forum.