| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Converting numeric data into 0 in spreadsheet
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 |
| Reply |
| 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 | |||
Linear Mode
