Converting in to mm

[AFDave]

I have been tasked to convert inches to mm in a huge excel document and I am only able to convert once cell at a time and I would like to be able to convert everything at once or a cell range.

Converting formula I have is =CONVERT(2.75, "in","mm")

Is there a way to use that in a range rather than typing in the number to convert?

Maybe a way I can have the cell multiplied by 25.4005?

 

[VoG]

Type 25.4005 into a spare cell. Copy it.

Select the range that you wish to change, Edit > Paste Special, check Multiply then click OK.

 

[AFDave]

Thanks!!! You just saved me a lot of time!!!