Hi

It depends on how the information is entered. If a cell contains 9 (meaning
9 inches) you can convert this to cm by multiplying by 2.54 (ish).
If all of the cells you wish to change are simply numbers like that, then
you can type 2.54 into a cell, copy it, select the range of numbers, and
Paste Special / Multiply.
It might be that we need more information on the layout/content of your
sheet.

--
Andy.


"Ted" wrote in message
...
I need to convert my entire spreadsheet from inches to centimeters. I
found
a way to convert a cell value, but is there a way to convert all the
values
in the spreadsheet?