I have a spreadsheet that is
Columns run A-AJ
Rows run 1 through 5136 (yes, five thousand + rows)

Someone else created it (database) and EVERY cell begins with what looks
like an apostrophe, but I cannot do a global search/replace to get rid of
them as I ususally do. Deleting the apostrophe cell by cell is NOT an option.

All the cells also have a small green triangle in the upper left-hand
corner. I am trying to change the phone number format from

0000000000

to

000-000-0000

I did a format change, but it will not show correctly unless I can remove
the apostrophes.