VBA to convert from text to numbers

[Vivek2705]

hii..

I used VBA code "Columns(1).texttocolumns" to convert text to numbers.

The issue is some of the text gets converted to Dates on running the macro which is being highlighted in yellow color.

any remedy for the same?

PFA

Thanks..

[davsth]

What are the correct answers? can you provide some? At the moment I can not see what you wish to achieve. Not all value sin the modified colum are numbers, but that is your aim? with the exception of the yellow cells the results are the same in both columns

[Vivek2705]

The yellow color cells should have same values as in A column..
Only the numbers stored as text should be converted to numbers & others all should remain same.

[Akuini]

Try this:
The data must not be filtered when you run the code.

Please Login or Register  to view this content.

[Vivek2705]

Thank You Akuini!!

[Akuini]

You're welcome, glad to help, & thanks for the feedback.