green triangles - not the usual problem

[nky_84]

Hi guys,

I have some reports that export to excel and the numbers are stored as text. I can remove the errors from my excel version through tools and untick the error checking, but if i send the file on, the appear again.

If i select all the cells and click ignore, this seems to work, however i have multiple report and multiple tabs in each and looking for a quicker solution if possible.

I have seen that there are macro solutions but would rather not have to do for each report that is created.

Anyone know of a quick way to ignore all errors, that will carry through to other machines?

Thanks

 

[SuperFerret]

I normally just protect the sheet but don't actually lock down the cells