Using a formula I wish to be able to convert the following examples 6.4m,
7.65m, 7.875m, 11.875m, 12.5 & 13.72m to 6400, 7650, 7875, 11875, 12500 &
13720 respectively. As you can see the descriptions used can be between 1 & 3
decimal places & always trailed by an m. Any help would be greatly
appreciated.

With data like yours in A1, use:

=1000*LEFT(A1,LEN(A1)-1)

--
Gary''s Student - gsnu200909


"Rocko" wrote:

> Using a formula I wish to be able to convert the following examples 6.4m,
> 7.65m, 7.875m, 11.875m, 12.5 & 13.72m to 6400, 7650, 7875, 11875, 12500 &
> 13720 respectively. As you can see the descriptions used can be between 1 & 3
> decimal places & always trailed by an m. Any help would be greatly
> appreciated.

Hi Rocko


With 7.65m in cell A1
=LEFT(A1,len(a1)-1)*1000

--
Regards
Roger Govier

"Rocko" <(E-Mail Removed)> wrote in message
news:3F39C5D0-619D-4418-A159-(E-Mail Removed)...
> Using a formula I wish to be able to convert the following examples 6.4m,
> 7.65m, 7.875m, 11.875m, 12.5 & 13.72m to 6400, 7650, 7875, 11875, 12500 &
> 13720 respectively. As you can see the descriptions used can be between 1
> & 3
> decimal places & always trailed by an m. Any help would be greatly
> appreciated.
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4752 (20100107) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4752 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Thanks to you both for your prompt relies, that works great. Have a good day.

Regards,

Rocko

"Roger Govier" wrote:

> Hi Rocko
>
>
> With 7.65m in cell A1
> =LEFT(A1,len(a1)-1)*1000
>
> --
> Regards
> Roger Govier
>
> "Rocko" <(E-Mail Removed)> wrote in message
> news:3F39C5D0-619D-4418-A159-(E-Mail Removed)...
> > Using a formula I wish to be able to convert the following examples 6.4m,
> > 7.65m, 7.875m, 11.875m, 12.5 & 13.72m to 6400, 7650, 7875, 11875, 12500 &
> > 13720 respectively. As you can see the descriptions used can be between 1
> > & 3
> > decimal places & always trailed by an m. Any help would be greatly
> > appreciated.
> >
> > __________ Information from ESET Smart Security, version of virus
> > signature database 4752 (20100107) __________
> >
> > The message was checked by ESET Smart Security.
> >
> > http://www.eset.com
> >
> >
> >
>
> __________ Information from ESET Smart Security, version of virus signature database 4752 (20100107) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
> .
>