CONVERT ENGLISH TO METRIC

netmog

New Member
Joined
Mar 14, 2002
Messages
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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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... :wink:
 
Upvote 0
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
 
Upvote 0
:eek:

there is a CONVERT formula (whichh I know you said you didn't want to use) in the analysis toolpack addin (i think?)
 
Upvote 0
On 2002-03-15 11:11, gplhl wrote:
:eek:

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")
 
Upvote 0
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.
_________________<font color = green> Mark O'Brien
This message was edited by Mark O'Brien on 2002-03-15 11:21
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,188
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top