Converting numeric data into 0 in spreadsheet

[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

[Tom Ogilvy]

selection.SpecialCells(xlConstants,xlTextValues).Value = 0

possibly.

--
Regards,
Tom Ogilvy


"deepakgoyal" wrote:

>
> 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
>
>
> --
> deepakgoyal
> ------------------------------------------------------------------------
> deepakgoyal's Profile: http://www.excelforum.com/member.php...o&userid=34839
> View this thread: http://www.excelforum.com/showthread...hreadid=545850
>
>