Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting numeric data into 0 in spreadsheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a letter to a numeric value | Excel Discussion (Misc queries) | |||
Converting a symbol to a numeric value? | Excel Discussion (Misc queries) | |||
Converting numeric data into 0 | Excel Worksheet Functions | |||
converting text to numeric data | Excel Worksheet Functions | |||
Converting text data type to numeric | Excel Programming |