View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alvin Alvin is offline
external usenet poster
 
Posts: 19
Default Fraction to decimal

I have a cell with a value of {0'-3/4}
I want another cell to call that value and change the format to
{0'-0 3/4"}

the following code will change it to a decimal when it is formatted correctly:
which is what I am after.

{=SUBSTITUTE(LEFT(H69,FIND("-",H69)-1),"'","")*12+SUBSTITUTE(REPLACE(H69,1,FIND("-",H69),""),"""","")}

Thanks in advance
Alvin Smith