How to add 'ft' to number input in cell - as in 25ft

R

Roger Govier

Hi Beth

the same as in earlier versions of Excel
Format>Cell>Number>Custom> 0.0 "ft"

Set the number of decimal places you want as appropriate.
25 entered in the cell will show as 25.0 ft with the above format. All that
is stored is the number 25, which can be used in subsequent calculations.
 
Top