View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Reggie1000 Reggie1000 is offline
external usenet poster
 
Posts: 2
Default treat text as blank

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