Is there a way to mass update the cell format an Excel Column of data that was general to number to avoid having to click on every cell to apply the change?
Alternately, select range. Text to Columns. Use char that doesn't exist in record as delimiter. Specify return column type or leave it as general. It will convert to number if it is numeric string.
