Thank you Ace_XL

That is definitely quicker! However, the finished result does not show
the formula, it enters the final value so I have tracability of what the
conversion was and no way to check if any cells were missed?? (clicking
on formula still shows the changed cell as a value)

Not to seem unthankful, because I am so thankful!, but is there a way to
do this action that leaves the finished formula visible for checking at a
later date?

Rachel