Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get a chart to print in millimetres | Charts and Charting in Excel | |||
how to print chart in millimetres | Charts and Charting in Excel | |||
How do I type 24 square metres using arithmetical notation | Excel Discussion (Misc queries) | |||
How do I type 24 square metres using arithmetical notation | Excel Discussion (Misc queries) | |||
How do I use the symbol for metres squared ie m2? | Excel Discussion (Misc queries) |