ExcelBanter - convert sheet t to metric

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - convert sheet t to metric (https://www.excelbanter.com/excel-discussion-misc-queries/247059-convert-sheet-t-metric.html)

James

convert sheet t to metric

is there any way to convert an entire sheet incl formulas from inperial
(inches) to metric (millimeters)?

Sheeloo

convert sheet t to metric

find the multiplier required to convert inches to millimeters - 25.4
Enter that in any cell away from your data
Copy that Cell
Select your data
Choose Edit-Paste Special and choose Multiply option and click OK

"james" wrote:

is there any way to convert an entire sheet incl formulas from inperial
(inches) to metric (millimeters)?

All times are GMT +1. The time now is 10:02 PM.