Format cell to show numbers as feet
 

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!

Format cell to show numbers as feet
 

SandmanLogan

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

Mike Rogers

"SandmanLogan" wrote:

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!