# Thread: Imperial to Metric conversion

1. ## 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. 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. Thanks Steve, there's always an easy way if only you know it!! Paste Special needs remembering.

Rob

4. Decimal inches! I knew the British were crazy, but that's just plain silly.

cheers, Paul

5. 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. Hi Paul

..and we play football with round balls.

zeddy

7. Don't they play "30.5cm - ball" in many parts of Europe?

Steve

8. Round ball football is sensible and worldwide, as is the metric system. Both should be played/used everywhere.

cheers, Paul

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