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