Hello. I have a back office database where I can export reports into excel. Unfortunately, the data on the reports are formatted as text within the sheet, making the information unusable for data manipulation using formulas and macros. Vlookups and other references return an "na" as a result of the formulas.
The data I want to use on the exported reports can be converted to numbers if selected and then choose "convert to numbers" but that defeats the purpose and doesn't allow for automation.
What can I do to convert the data of an entire sheet from text to number format using a macro or other technique?
Thank you.
The data I want to use on the exported reports can be converted to numbers if selected and then choose "convert to numbers" but that defeats the purpose and doesn't allow for automation.
What can I do to convert the data of an entire sheet from text to number format using a macro or other technique?
Thank you.