Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Converting length from metres to millimetres

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Converting length from metres to millimetres

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default Converting length from metres to millimetres

Hi Rocko


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

--
Regards
Roger Govier

"Rocko" wrote in message
...
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



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Converting length from metres to millimetres

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" wrote in message
...
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



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i get a chart to print in millimetres alancook Charts and Charting in Excel 1 April 15th 07 06:22 PM
how to print chart in millimetres alancook Charts and Charting in Excel 1 April 15th 07 05:49 PM
How do I type 24 square metres using arithmetical notation Howard Excel Discussion (Misc queries) 5 August 2nd 05 02:14 AM
How do I type 24 square metres using arithmetical notation Hayeso Excel Discussion (Misc queries) 0 June 24th 05 03:14 PM
How do I use the symbol for metres squared ie m2? Chris Excel Discussion (Misc queries) 2 November 30th 04 05:45 PM


All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"