True I was assuming ##?#. If #?## exists then we need to add an if statement
similar to

=IF(ISERROR(VALUE(MID(A2,2,1))), VALUE(LEFT(A2,1)+(VALUE(MID(A2,3,2)))/100),
VALUE(LEFT(A2,2)+(VALUE(MID(A2,4,1)))/10))

HTH

"Fredrik Wahlgren" wrote:


"Jim Thomlinson" wrote in message
...
Lets see if I can do a little better on this than I did on your last. Try
this formula to get the value

=VALUE(LEFT(A1,2)+(VALUE(MID(A1,4,1)))/10)

Where 12.2a or 12,2a is in cell a1

HTH


Yes that is excellent assuming there are no entries like 6.25a
/fredrik