10-4 136
10-5 135
10-6 134
10-7 133
10-8 132
10-9 131
10-10 150
10-11 151
10-12 152
10-13 153
11-0 154
11-1 153
11-2 152
11-3 151
11-4 150
11-5 149
11-6 148
11-7 147
11-8 146
11-9 145
11-10 164
11-11 165
11-12 166
11-13 167
12-0 168
12-1 167
12-2 166
12-3 165
12-4 164
12-5 163
12-6 162
12-7 161

Judith this is what is returned using your formula the correct value is
returned in some cases but the incorrect value is returned in other cases
any other suggestions to remedy this.

Your help is much appreciated.

Regards

Eamon

PS I have it working with
=(LEFT(A1,2)*14)+(RIGHT(A1,1)

Thanks also to Chuck

"JudithJubilee" <anonymous@discussions.microsoft.com> wrote in message
news:15a801c50ab1$869380b0$a401280a@phx.gbl...
> Hello there,
>
> You need to extract the left 2 digits and times by 14
> plus the right 2 digits:
>
> A1 = 10-12
>
> =(LEFT(A1,2)*14)+(RIGHT(A1,2))
>
> Hope this helps
>
> Judith
>
>>-----Original Message-----
>>Hi,
>>
>>How can I convert Stones and Lbs to Lbs
>>i.e. in A1 10-12 (10st - 12Lbs) what formula could I use
> in B1 to return 152
>>(lbs)?
>>
>>Any suggestions would be most welcome.
>>
>>Regards,
>>
>>Eamon
>>
>>
>>.
>>