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!