Hide Errors
Right click the range and select Format Cells, Number, Custom
Use this format
[Black]General
Then change the font color to the same color as your cell background (usually white)
It will show regular entries but hide errors.
© Copyright
andrewsexceltips.net
. All Rights Reserved.