Thanks:  0
Likes:  0

# Thread: CONVERT ENGLISH TO METRIC

1. Is there a way to convert #'s from english (in) to metric (cm) in Excel or Access WITHOUT creating a new cell?- i.e. convert an entire column without creating new "formula cells".

Thanks!

[ This Message was edited by: netmog on 2002-03-15 11:13 ]

[ This Message was edited by: netmog on 2002-03-15 11:14 ]

2. You mean as you type?

3. Enter 2.54 into an unused cell, Copy it, select your values to be converted from inches to centimeters, and perform a Paste Special... Values Multiply.

[ This Message was edited by: Mark W. on 2002-03-15 11:02 ]

4. isn't it 2.54?
or 0.393701 inches per centimetre

_________________
Regards,

Gary Hewitt-Long

[ This Message was edited by: gplhl on 2002-03-15 10:56 ]

5. Hi

Imperial is English measurements in liquid volume and distance, and is feet and inches or pints

Im with Gary 2.54 in UK is imperial. so as Mark W says but 2.54.

I saw an addin to do this sop can type 6' 2" and next col X ofset left one and enter gives M + CM, can recal where .. look uop in google.

HTH

BTW the addin goes both ways imperial to metric and back.

6. On 2002-03-15 10:55, gplhl wrote:
isn't it 2.54?
or 0.393701 inches per centimetre

_________________
Regards,

Gary Hewitt-Long

[ This Message was edited by: gplhl on 2002-03-15 10:56 ]
Yes, I can't type...

7. Not so, it was hardle deliberate, i can spell can i and im English!

dont woory about it Mark... no harm done.... you post billions and help billion.. thats they bit thats conunting

8. :o

there is a CONVERT formula (whichh I know you said you didn't want to use) in the analysis toolpack addin (i think?)

9. On 2002-03-15 11:11, gplhl wrote:

there is a CONVERT formula (whichh I know you said you didn't want to use) in the analysis toolpack addin (i think?)

Yes, there is. I used it to determine the conversion factor...

=CONVERT(1,"in","cm")

10. Quick note. (and word of caution)

There is a difference between some "Imperial" units (i.e. the old British System) and what North Americans call "English" units, especially with volumes. For example

1 Imperial gallon (or UKGal) = 4.546 litres
1 English gallon (or USGal) = 3.785 litres

The irony of North Americans calling their units "English Units" when they are actually different from what the English use (or used to use) never fails to amuse me and I've been in the States for 2 years.

Another word of caution, be careful when asking for a pint in the US, it's a lot less than a British pint. That was a harsh lesson for me.

And I don't think the CONVERT functions discriminates between US and UK gallons. It does for pints though, which is strange.
_________________
[b] Mark O'Brien

[ This Message was edited by: Mark O'Brien on 2002-03-15 11:21 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•