Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: Inches to Millimeters function

0 views
Skip to first unread message

Dave R.

unread,
Dec 6, 2004, 3:17:28 PM12/6/04
to
Here you go

=CONVERT(A1,"in","m")*1000


"Tami" <Ta...@discussions.microsoft.com> wrote in message
news:E76C9C93-5BC8-4858...@microsoft.com...
> Is there a function in excel that can convert inces to millimeters?
>
> Thanks in advance for your help,
> Tami


N Harkawat

unread,
Dec 6, 2004, 3:14:50 PM12/6/04
to
=A1*25.4

Dave R.

unread,
Dec 6, 2004, 3:20:33 PM12/6/04
to
oops, just noticed that you can use "mm" instead of "m" and can drop the
*1000 part.

Harald Staff

unread,
Dec 6, 2004, 3:25:26 PM12/6/04
to
Multiply by 25.4, there are 25.4 millimetres in each inch.

HTH. Best wishes Harald

"Tami" <Ta...@discussions.microsoft.com> skrev i melding

Tami

unread,
Dec 6, 2004, 3:11:04 PM12/6/04
to
0 new messages