Replace any Non-Numeric CELLS i.e. Entire Contents with a Zero in a Specified Range

Please read the yellow banner at the top of this page on how to attach a file.

Are you still using XL2007 or have your upgraded to a later version. If later, then please adjust your profile so that we can use the latest techniques.

I am using Excel 2007 at Work and Excel 2010 at Home.
I have uploaded the attachment with a RANDOM CODE to add any wild card character which needs to be replaced with a zero or blank but the entire cell and not just the character.
This is an example of how the data is received so just created a mock example using the RANDBETWEEN and CHAR...

I only want the cells to contain numbers and nothing else.

Hi, e4excel,

what about trying SpecialCells like

Please Login or Register  to view this content.

which should take care of any text in any cell in the given area.

Ciao,
Holger

Hi, e4excel,

sorry but that was none of my best ideas as I found out afterwards.

Please try this sniplet instead:

Please Login or Register  to view this content.

Ciao,
Holger

Originally Posted by e4excel

I receive data from an external source where there are certain cells which contain Alpa-Numeric entries which can be anything other than numbers such as Alphabets and WildCard Characters , these cells need to contain only Numeric Entries and nothing other than numbers.

Now as these can contain anything and everything its difficult to Replace the same with a Zero.
I was looking for some code to FIND anything other than the numbers from 0 to 9 or any number with zero.

Not really sure though.

Please Login or Register  to view this content.