Ghost Apostrophe


I'm importing data directly from out accounting system via API into Smartsheet. For weeks things worked seamlessly. Nothing changed on my end, and the data started importing with an apostrophe at the beginning which is causing it to be read as text instead of a number. Which in turn is breaking all of my formulas. It's easy enough to delete the apostrophe, but manually everyday is too much.

No helper column, I don't want a hack or workaround- everything I've read in the community is this is a Smartsheet bug. Any help will be greatly appreciated.