Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: CONVERT ENGLISH TO METRIC

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You mean as you type?
    Regards,

    Gary Hewitt-Long

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    :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

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #10
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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