Measurement Units in Excel 2003

[Guest]

Hi This might seem like a silly question but I cannot seem to find the
measurement units in Excel 2003. I am teaching a MOS course in Excel Core
and one of the students asked how one would know if the system was in
Centimetres or inches - I thought it was in pixels for Excel but one of the
MOS mock exam questions asks the delegate to change the Page Setup margins to
1" or 2.5cm ???

Please help me to explain....

Ann

Thank you very much

 

[Guest]

The units of measure are set in Windows by clicking START/SETTINGS/CONTROL
PANEL. In the list of items in the Control Panel, double click REGIONAL
OPTIONS and set the measurement to METRIC.

To convert values in an Excel spreadsheet look up the CONVERT() function in
Excel Help

 

[Gord Dibben]

Units are governed by your Regional and Language Options in Control Panel.

I Excel, if you go to File>Page Setup>Margins you will see which units you are
set for.

Change from metric to imperial in settings as above.

As far as row heights and column widths go...............

Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the inch.

The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.

For an interesting and enlightening discussion on this subject see

http://snipurl.com/dzz8


Gord Dibben MS Excel MVP

 

[ShirleyC]

Did either of the posts answer your question? I have something odd happening
with measurements. I use office 2003 at home and work. At home, I have
inches for margins in everything but excel which is showing up as metric.
Everything at work is in inches so going back and forth between the two
locations and having to convert to get similar page setups is a pain.

If all programs units of measure are dictated by control panel settings, the
behavior on my home system doesn't make sense.

Any pointers?