Still getting some incorrect returns using =(LEFT(A1,2)*14)+(RIGHT(A1,1)
i.e. 10-12 returning 142 instead of 152

Regards

Eamon

"Eamon" <eamonbyrne2003@eircom.net> wrote in message
news:bPJMd.46892$Z14.31181@news.indigo.ie...
> 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
>>>
>>>
>>>.
>>>
>
>