 Units of measurement
in Excel
Units of measurement have no meaning in Excel because it is manipulating numbers and
doesn't take notice of units. If you want cm to appear next to the number
you would probably put cm in the cell next to the number to indicate to the user that the
unit is cm. Then you would grab the handle of the cell marker and drag it down to copy the
screen label to subsequent cells.
Now, having said that there is another way of doing this. Go to a cell and type a number
eg. 2. With your cell marker in the cell with the number, choose Format | Cells |
Number. In the Category column, choose Custom.
You then type the format for the number you want and put any text that you want in double
quotes.
Example:
| 0.00"cm" |
will display |
2.00cm |
| 0.00" cm" |
will display |
2.00 cm |
| 0"cm" |
will display |
2cm |
| 0" cm" |
will display |
2 cm |
In Word, it is a different story.
To set the units as centimetres, choose Tools | Options | General. At the
bottom of the dialog box you will see Measurement Units - change it to
centimetres. |
