Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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" wrote in message ... 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? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel window in spread sheet? | Excel Discussion (Misc queries) | |||
I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
Linking to an Entire Sheet | Links and Linking in Excel | |||
HOW TO CONVERT EUROS TO SWISS FRANCS IN A EXCEL SPREAD SHEET | Excel Worksheet Functions | |||
How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) |