Macro to covert Text to Numbers

[Howardc1001]

I have written code to covert text to numbers, but the text is not being converted to numbers


It would be appreciated if someone could amend my code

Please Login or Register  to view this content.

[Rick Rothstein]

Your macro has some errors in it which I have corrected below (see Note 1 below). Also, you should compare my code to yours to see what I changed (besides the indenting).

Please Login or Register  to view this content.

NOTE 1: Your sheet is named "Sheet1" not "Data" so I changed that in the code; you were missing a With statement; the quote marks around the "A" in your Cells object were the wrong kind of quote marks.

NOTE 2: You have manually set the cells' horizontal alignment to "Left Align"... you should remove that.

[Howardc1001]

Thanks for the help Rick

I have noted your comments

[jolivanes]

Please Login or Register  to view this content.

Rick touched on the fact that you were left aligned (not you as such but the data)