feet and inches

[Guest]

i am trying to get a cell to enter
8'x9' by just entering 8x
also
if i enter 42-1/2x24 i want it to return 42-1/2"x24
i can find nothing on feet and inches in the help.

 

[Norman Harker]

Hi Brian!

Entries like 8x9 are treated as text and you can't format to add the '

For feet and inches that you can use as numbers you can enter:

6 7/12
Format
# #/12

For multiplications you can use:

=9 * 6 7/12
Format # #/12

See:
Chip Pearson:
http://www.cpearson.com/excel/fractional.htm
and
Dave McRitchie:
http://www.mvps.org/dmcritchie/excel/formula.htm#GetFormatExample
and
http://www.mvps.org/dmcritchie/excel/fractex1.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.