![]() ![]() H ttp://supp ort.micros oft.com/de fault.aspx /kb/214118 You can read the Microsoft Knowledgebase article here I could make InchCalc hide this problem from you by rounding in the incoming inches to, say, 10 decimal places but I generally prefer to have things fail quickly and explicitly rather trying to hide the problem only to have it show up unexpectedly in a seemingly unrelated cell. You might be very surprised to see that the answer is NOT zero. Try typing the following formula into Excel (any Excel spreadsheet, InchCalc *NOT* required) (But you can preserve the decimal number in a hidden field for calculation purposes.) If you want the ft and in in one field, then you have to give up the number quality. Just put whatever text you want in quotes, and remember double quotes inside double quotes will not work. You can use the ' and '' (use two single quotes) marks if you like, and you can also put a - before the inches. ![]() Format Cell -> Custom -> type in the box or if you want the space first. ![]() If you're not picky, and you're just looking for presentation, then you can use custom formatting to make them look correct. You now have one column with the feet, another with the inches. Extracting the feet involves the INT formula: =INT(A1/12). Assuming 98 inches is in cell A1, that formula will return a value of 2. You can create a column with just the inches component by using the formula: =MOD(A1,12). 98/12 = 8 1/6.)Ĭonverting 98 inches to 8'2" however is achievable in a few steps, but the output will be a text field, not a number field. If you pick the "up to two digits" type (and don't force 8ths, 16ths, etc.) then Excel will magically conver to the simplest fraction. Excel has a built-in "fractions" number type. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |