Can someone please tell me that formula? Thanks!
Can someone please tell me that formula? Thanks!
can you give an example of decimal
1' 2"
2" is 2/12 or 1/6 or 0.16666667
so do you 1.16667
so the decimal is a fraction of feet
how are you inputting the value of feet and inches into a cell
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
=CONVERT(1,"in","m")
or
=SUM(CONVERT(1,"in","m"),CONVERT(1,"ft","m"))
Last edited by sandy666; 04-15-2015 at 05:10 PM.
Here's a Function:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Assuming you want 1'2" in the form of a decimal number of feet, as shown by etaf:
Formula:Please Login or Register to view this content.
Jazzer-your formula only modifies once cell ...or can modify a column span of cells that outputs to the adjacent column? Thanks!
It returns a result based on one cell. You can copy it down an entire column for as many cells as you want.
Your question suggests that you may not understand how Excel formulas work. A formula doesn't modify a cell--the original cell is left untouched. A formula returns a value. So if your data is in column A, you can copy my formula to column B and see the conversion results there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks