The custom number formatting feature in Excel changes the appearance of values in a cell without altering the original content.
In this training, I will show you how to hide a cell content with value and still reference that cell in a formula – You will notice that even though the cell content is hidden, it still calculates perfectly.
Watch how this works here
Download the workbook used in this tutorial HERE
Ensure you practice along for better understanding.
Hey!
I will love to know if you got value from this video tutorial.
Kindly use the comment section to send your feedback as this will help serve you better.
Do well to share this value tip with others.
Amaka Cares!
#dexcelcoach