Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need help converting a column from "cm" to "mm".
One way:
Enter 10 into any blank cell. Copy the cell containing 10. Select the range holding your values in cm. Edit PasteSpecial Multiply. Hope this helps Rowan "LabLost" wrote: I am working on a Lab excercise using measurements. I had to measure 100 leaves and enter the data in Excel. Now I need to convert my measurements from centimeters to millimeters. I can do it manually but I know there has to be a short cut. I tried the convert function but evidently I am not entering the data correctly and it keeps giving me a #N/A error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) |