feet and inches

[Brian]

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

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/fractional.htm

 

[Norman Harker]

Hi Brian!

Please don't post the same question to different groups as it can
waste the time of people trying to help you.

Here is the answer given down the road in worksheet.functions:

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.