Converting numeric data into 0 in spreadsheet

D

deepakgoyal

Hi

I am working on a excel spreadsheet. It contains text dat 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 they 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
..
Thank you very much in advance
Deepak
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting numeric data in Spreadsheet to zero 2
Converting numeric data into 0 1
Sumproduct & VBA 4
copy and past numeric values only 3
A data validation question 1
Data Validation 4
passing a non numeric cell for numeric comparison 2
delete rows with 0 values 1

Top