Table cell format auto-changing

[Anonymous]

We are having problems with cells within a table changing format (from whole or decimal number to text) when the drawing is saved, closed then re-opened. This makes our formula cells go to ####.
How can we stop this?