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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.