How do i convert my entrie spreadsheet from inches to millimeters
How do i convert my entrie spreadsheet from inches to millimeters
(OP)
I am trying to convert inches to millimeters in excel. I have an entire workbook to convert. I do not have the time to change all of these cells. Is there a way to convert each entrie spread sheet in the workbook without plugging in the conversion formula for each individual cell? PLease Help Me!!!!!!!!!!!!!





RE: How do i convert my entrie spreadsheet from inches to millimeters
RE: How do i convert my entrie spreadsheet from inches to millimeters
RE: How do i convert my entrie spreadsheet from inches to millimeters
It's just a spreadsheet full of numbers?
RE: How do i convert my entrie spreadsheet from inches to millimeters
RE: How do i convert my entrie spreadsheet from inches to millimeters
to calculate the remaining wall and percentage wall loss? But the heart of the spread sheet are all manually entered numbers. I do not have the time to implement each individual cell with the formula =Convert(.579,"in","mm") Okay.
RE: How do i convert my entrie spreadsheet from inches to millimeters
example: =+Sheet1!H23/25.4
RE: How do i convert my entrie spreadsheet from inches to millimeters
In any blank cell enter the conversion factor 25.4.
Select that cell and press control+C to copy.
Select a column or columns of cells that have only numbers that represent inches.
Go to "Edit" on the menu bar and select "Paste Special..."
Select the "Multiply" option, then press OK.
Poof!
RE: How do i convert my entrie spreadsheet from inches to millimeters
RE: How do i convert my entrie spreadsheet from inches to millimeters