Posted to microsoft.public.excel.worksheet.functions
|
|
function to change metric measurements
The base units are mm to be converted to m, cm or left as mm.
So we always start with 1234 mm =1.234 m or 1m 23.4 cm = 123 cm 4mm (123.4 cm)
"Bearacade" wrote:
I am not sure you are giving us the right example of what you want..
1234m does not equal to 1 M 23.4 CM
nor does 1234cm = 123 cm 4 mm and vise versa..
I did take what I think you meant and put this into a formula (it's not
pretty, but it works) and you don't have to set up a macro or fuction,
so that if you put:
1234mm will convert to cm and mm (123 cm 4 mm)
1234cm will convert it to M and cm (1 M 23.4 cm)
you can play around with this.
=IF(RIGHT(A1,2)="mm",QUOTIENT(LEFT(A1,LEN(A1)-2),10)&" cm
"&MOD(LEFT(A1,LEN(A1)-2),10)&"
mm",IF(RIGHT(A1,2)="cm",QUOTIENT(LEFT(A1,LEN(A1)-2),1000)&" M
"&MOD(LEFT(A1,LEN(A1)-2),1000)/10&" cm"))
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=559040
|