Converting length from metres to millimetres

  • Thread starter Thread starter Rocko
  • Start date Start date
R

Rocko

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 said:
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
Click to expand...

__________ 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
 
Back
Top