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.