View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
deepakgoyal
 
Posts: n/a
Default Converting numeric data into 0


Hi

I am working on a excel spreadsheet. It contains text data and numeric
data. what I am looking for is that I need to convert that numeric data
into 0. I mean there are cells which contains values like 234, 22, 12
etc and there are blank cells in between them. So is there a way by
writing a command or Macro to convert that numeric data to 0, ie each
field must contain a value 0