Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parse Cell Around "Dash" in Data
Though I understand Excel is a math system, and would see .1 and .10 as
the same number, my users do not. The user gets data from suppliers, that shows: Feet.Inches x Feet.Inches 12.1 x 8.10 9 x 7.5 11.10 x 10.9 (and so on) Seeing these numbers as Feet dot (.) Inches, he wants to know the Square Yardage value of the piece of carpet. The problem is that 12.1 and 12.10 is the same number to Excel, but it's 12 feet 1 inch in one case and 12 feet 10 inches in the other. I can get the Integer, always, with the Int function, but I can't figure out how to get the inches. If I can convert each column (length and width being the 2 columns) to inches, I can get square yards by using the formula (with cell references): Inches (of Length) * Inches (of Width) / 1296 Any ideas? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding data only if adjacent to cell labeled "male"/"female" | Excel Worksheet Functions | |||
Replace "dash" with "space" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
What does the double dash or "--" do when using it in a function? (and other questions) | Excel Worksheet Functions | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |