CONVERT ENGLISH TO METRIC

netmog · Mar 15th, 2002, 11:47 AM

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 ]

gplhl · Mar 15th, 2002, 11:49 AM

You mean as you type?

Mark W. · Mar 15th, 2002, 11:50 AM

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 ]

gplhl · Mar 15th, 2002, 11:55 AM

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 ]

Jack in the UK · Mar 15th, 2002, 12:01 PM

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.

Mark W. · Mar 15th, 2002, 12:03 PM

Quote:

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...

Jack in the UK · Mar 15th, 2002, 12:08 PM

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

gplhl · Mar 15th, 2002, 12:11 PM

:o

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

Mark W. · Mar 15th, 2002, 12:14 PM

Quote:

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")

Mark O'Brien · Mar 15th, 2002, 12:19 PM

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 ]

Mar 15th, 2002, 11:49 AM	#2
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	You mean as you type? __________________ Regards, Gary Hewitt-Long

Mar 15th, 2002, 12:01 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	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. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 15th, 2002, 12:08 PM	#7
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	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 __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 15th, 2002, 12:11 PM	#8
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	:o there is a CONVERT formula (whichh I know you said you didn't want to use) in the analysis toolpack addin (i think?) __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 11:47 AM	#1
netmog New Member Join Date: Mar 2002 Posts: 6	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 ]

Mar 15th, 2002, 11:50 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Mar 15th, 2002, 11:55 AM	#4
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	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 ]

Mar 15th, 2002, 12:19 PM	#10
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 ]