View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Formatting cells

You need to convert the measurement to a decimal number. I assume your
example means 5 feet 6 1/4 inches. To convert this you can enter it as:-
=5+6.25/12 (Which is easy because everyone knows 1/4 = .25)

However if you don't know the decimal equivalent you could enter it as:-
=5+6/12+1/4/12

Regards,

OssieMac






--
Regards,

OssieMac


"Tom J" wrote:

Is there a way to format cells to recognize dimensions as for use in formular
operations. i. e. 5'-6 1/4"