Merge that cell with an adjacent one. Only other thing I can think of is to
change the formatting to something that fits in the cell.

" wrote:

I have formatted a number as 0.00" C/Mtres" and it returns the result
of #### because the column is too narrow.
If I don't want to make the column wider or reduce the size of the
font how do I fix this?