Converting text to numbers in multiple sheets while leaving missing values blank

[andes666]

Hi everybody,

I have an Excel workbook with around 100 worksheets. All of them have similar columns, but the values are stored as text. The length of columns and missingness is different in different worksheets. I will be grateful if any of you could suggest a VBA that could convert the numbers stored as text back to numbers. I have been looking for an answer for a while, but cant seem to find one that automatically looks at every worksheet and converts text into number.

Many thanks for your timely help.

Best wishes

Andes

[Alf]

Perhaps this macro could be of use?

Please Login or Register  to view this content.

Alf