You can test the cells within your formula with ISTEXT or ISNUMBER to avoid
the errors... we can help more if you can share the formula you are trying to
use...

"Reggie1000" wrote:

is there a way to have text in a spreadsheet treated as blank - I paste in
yachting elapsed times to do some calculations but the cells with DNC cause
problms. Can i run a formula to treat or convert them to blank fields?
--
PT