Assume the cell where the date is entered is A1:

If IsNumeric(Range("A1") = True Then
'Your regular code here
Else
'Exit Sub?
End If

"Albert Mulder" wrote:

I have a user entering data into a cell then that data is used through out
the page, but if the user does not enter any data into a cell all the other
cells get ### entered onto them.

The user does not need to enter data into every cell, only the ones he
needs. How can I do it so that instead of showing ## it shows nothing just a
blank cell?

I would think it would be an if then but not sure how. The data the user
would enter will always be 0-9 only.