On Sun, 18 Jul 2004 12:07:21 -0700, keepITcool wrote:

Carl

This should do:
but it will work only for excel 2000 or newer..


Function ConvMM(s As String)

One of us is misunderstanding something.

For input of

300x200x100

The OP's formula gives:

11 13/16" X 7 14/16" X 3 15/16"

My (revised) UDF gives:

11 13/16" X 7 7/8" X 3 15/16"

but your UDF gives (on my machine -- XL 2002):

12 1/16 X 8 1/16 X 100



--ron