How to format number and not return ######

  • Thread starter Thread starter gavin_scott
  • Start date Start date
G

gavin_scott

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?
 
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.
 
Although I should also mention I'm not a fan of using merged cells (except
occasionally for headers, but never for data). I've heard they can cause
other problems (particularly if you have macros that work with said data).
 
That "change the formatting to something that fits in the cell" might be as
simple as selecting Format Cells, clicking the Alignment tab and placing a
checkmark in the "Shrink to fit" check box under the "Text control" section.

Rick
 
Rather than merging, you may wish to centre the content of that cell across
a group of cells.
 
Back
Top