Excel Forum

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.