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

Converting numeric data into 0
 

Hi
Hit F5 and select Special. In there select Constants and Numbers. You can
then hit 0 and Ctrl Enter to replace the values with 0.

Andy.

"deepakgoyal"
wrote in message
...

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

Thank you very much in advance
Deepak


--
deepakgoyal
------------------------------------------------------------------------
deepakgoyal's Profile:
http://www.excelforum.com/member.php...o&userid=34839
View this thread: http://www.excelforum.com/showthread...hreadid=545851