BadBunny, I tried your code and found that after changing the cell format, the line .Value = .Value did, indeed, convert the number-as-text to an actual number.
KjBox, a loopless solution would be great and may exist, but I did not find that numbers-as-text got changed into actual numbers using your solution.
Edit: Well, duh. Of course it can be done. Just replicate BadBunny's solution by adding another line:
(Can surely be cleaned up further using a With statement.)