Text to Value
Hi. I have a column of numbers. Before my code executes, I would like to
check the column to make sure all numbers are truly numbers. Every so often
a number slips in with a ' in front of it, making it text. Is there a
simple way to remove the ' in cells where it occurs? I tried to use
edit/replace, but MS said it could not find the '. Thanks!
|