Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Match Each Numeric occurrence and Return Individual Rows of Data | Excel Worksheet Functions | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Converting data from a pasted document | Excel Worksheet Functions |