selection.SpecialCells(xlConstants,xlTextValues).V alue = 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