| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting cells
Is there a way to format cells to recognize dimensions as for use in formular
operations. i. e. 5'-6 1/4" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting cells
Just as a suggestion, enter the feet, inches and fractions in separate cells
and create another cell with the result. -- Regards, OssieMac "OssieMac" wrote: 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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Formatting cells | Excel Discussion (Misc queries) | |||
| Formatting cells | Excel Discussion (Misc queries) | |||
| Formatting Cells | Excel Discussion (Misc queries) | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Hybrid Mode
