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.