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

  • Thread starter Thread starter bethgames
  • Start date Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=CONVERT(A2,"in","ft") 5
Just for TC 2
A single Page print for key items 1
Function Error 4
Please advise on length addition! 3
Excel How to add numbers in same cell? 2
convert formula 5
Numbers showing Up Centered in Cell ? 1

Back
Top