Thank you Scott. That works well.

I've seen the "box" before and did not ever click it so was not aware of
that method.

Good to learn new things.

"ScottL" wrote:

Select the cells with the apostrophes and when the error checking box appears
(the reason for the green triangle) click on it and select "Convert to
Number". Then change the format of the cells to your custom format.