I have a routine where a column with integer values is formatted as dates.
When the value can't be displayed as date, for example something like
18500618, it will be displayed in the
sheet as hashes. I need to check for this happening and do a conversion. I
have tried to do this check on the
actual value in the cell, but that doesn't always work, so I would like to
check for the displayed hashes.
This now is not that easy. Just checking for the character # isn't
foolproof.
Thanks for any advice.

RBS