Macro to change number format of cell values

Hi. Has anyone every encountered this problem: You receive an Excel spreadsheet that has all the cells formatted as GENERAL. The cells contain numbers, but the format of those number values is not really NUMBER. Therefore, these values fail to calculate in mathematical and lookup formulas. So to fix it, you have to place your cursor in the cell and click ENTER in order to refresh the cell. Then, the format of the value within the cell converts to NUMBER, and your formulas start to work.

Please see my attached spreadsheet. Is there a macro that can convert the values in column A to DATE, and the values in column B to NUMBER?

I know of a trick using the COPY PASTE SPECIAL VALUES - MULTIPLY by 1.0 method, but I was wondering if the process could be more automated with a macro.

Any advise is greatly appreciated.

You have more than one format in each column...
General in the upper section and Text in the lower section

Not a macro, but this is pretty quick....

Select the 2-col range of cells
[Ctrl]+[Shift]+~........a shortcut to convert the cells to General format

Select the Col_A values
<data><text-to-columns>
Click [Next] until Step 3 of 3
Check: Date....YMD.......Click [Finish]
(That converts them to dates)

Select the Col_B values
<data><text-to-columns>
Click [Next] until Step 3 of 3
Check: General.......Click [Finish]
(That makes the values numbers)

Done (you may want to format the date cells)

Does that help?