I would like to change the non numeric cells in column A (Number) to the value 0.
I have tried this to remove the text, but the problem is that I then get some cells that are filled with a lot of numbers instead of just the “0”. Also those cells that contain numbers as well as text need to become “0” e.g. 4/17/#4.
I have used the following method based on Excel Data Manipulation Advice
row.Item(“Number”) = System.Text.RegularExpressions.Regex.Replace(row.Item(“Number”).ToString,"[^\d+]",“0”).ToString
What would be a good way to solve this?
Thanks in advance!
Numbers.zip (7.9 KB)