Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Dec 2009
    Location
    Edinburgh, Scotland
    Posts
    85
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Imperial to Metric conversion

    I've three columns by 100 rows of decimal dimensions in inches. How can I do a block multiply by 25.4 to get these to millmetres ?

    Thanks

    Rob

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    put 25.4 in a cell.
    select that cell and copy it
    select the range of cells to convert
    right click- paste special
    choose multiply

    Steve

  3. #3
    Star Lounger
    Join Date
    Dec 2009
    Location
    Edinburgh, Scotland
    Posts
    85
    Thanks
    10
    Thanked 0 Times in 0 Posts
    Thanks Steve, there's always an easy way if only you know it!! Paste Special needs remembering.

    Rob

  4. #4
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,175
    Thanks
    47
    Thanked 982 Times in 912 Posts
    Decimal inches! I knew the British were crazy, but that's just plain silly.

    cheers, Paul

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Paul,
    If you don't like decimal inches, all it takes is formatting to display as fractions:
    # ??/??

    will display as up to 2 digits...

    Steve

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Paul

    ..and we play football with round balls.

    zeddy

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Don't they play "30.5cm - ball" in many parts of Europe?

    Steve

  8. #8
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,175
    Thanks
    47
    Thanked 982 Times in 912 Posts
    Round ball football is sensible and worldwide, as is the metric system. Both should be played/used everywhere.

    cheers, Paul

  9. #9
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    round ball football and metric system don't mix.

    Penalties are taken from 12 yards, goalposts are 8 yards apart and it's 8 feet high.
    ..and kick-off starts at the centre of a 10-yard circle.

    Lets not even talk about cricket - that's got a pitch 22 yards long, which, in old money, is a 'chain'.
    ..and in horse-racing we still use furlongs (that would be ten chains), unless you prefer 201.168 metres.
    ..and no matter how small your garden is, you should always keep back one or two acres to grow wild (an acre is an area that is one furlong long and one chain (66 feet or 22 yards) wide)

    long live imperialists!
    say no to ten-eggs-in-a-box

    zeddy

Posting Permissions

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