Format cell to show numbers as feet

G

Guest

Help!

I am trying to determine a way to input numbers into a cell that will
automatically show them as feet. For example, I input 123 and the cell shows
it as 123'.

I have looked at all of the formats but cannot find one that will show a
number as a foot. Is there anyway to do that? I'd love any help.

Thanks!
 
G

Guest

SandmanLogan

Goto format cell>custom, enter 0"'" and ok out. This gives you what you are
asking for.

Mike Rogers
 

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

format cell 1
Numbers showing Up Centered in Cell ? 1
How to format feet/inches (ft'in") 4
How can I show Feet and inches in a Excel cell? 1
format phone numbers with an 800 2
display number as feet and inch in single cell 5
format cell with multiple formats for telephone numbers 1
Formating cells to add in feet and inches 1

Top