Format cell to show numbers as feet

S

SandmanLogan

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!
 
M

Mike Rogers

SandmanLogan

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

Mike Rogers
 
Top