Hi,
i looked at the posts but could not find exact one. I have a column,
say A:A filled with numbers and text stored as text. i want the
conversion only to the numbers not to the text. Here is an example

1000
2000
2000A
3000

All these are stored as text and i want to convert only numeric
ones..I tried to use "ISNUMERIC" but did not worke as number were
stored as text.

Please help.

(Recording Macro is not helping)

musa.biralo