Hi,
I picked up this formual in a previous thread. It converts Feet and inches to Decimal feet.
=LEFT(B2,FIND("-",B2)-2)+SUBSTITUTE(REPLACE(B2,1,FIND("-",B2),""),CHAR(34),"")/12
For example it converts 406'-11 1/8" to 406.9271.
The problem is it gives me an error message "#value" if the number being converted is a negative number
eg -373'-2 3/16" returns the "#value" .
If I remove the minus sign i get the correct conversion 373.1823 but I don't want to have to keep removing the minus and then reinserting back in.
Does anybody know how to change the formula that will convert the negative numbers
Cheers
Bookmarks