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