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