How do I convert an entire spread sheet form inches to centimeters

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?

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" <[email protected]> wrote in message
news:[email protected]...
>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?

> 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).

Actually, the 2.54 is an exact conversion, so there is no 'ish'

Bernie
MS Excel MVP

Thanks Bernie! I didn't check and I didn't want to mislead the poster!!

--
Andy.


"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
>> 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).
>
> Actually, the 2.54 is an exact conversion, so there is no 'ish'
>
> Bernie
> MS Excel MVP
>
>

Is there a way of dealing with cells that have formulas in them? In version
2000 I could accomplish that doing cell format.

"Andy B" wrote:

> Thanks Bernie! I didn't check and I didn't want to mislead the poster!!
>
> --
> Andy.
>
>
> "Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
> news:[email protected]...
> >> 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).
> >
> > Actually, the 2.54 is an exact conversion, so there is no 'ish'
> >
> > Bernie
> > MS Excel MVP
> >
> >
>
>
>