Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Measurement Units in Excel 2003
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 -- Kind regards Ann Shaw |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Measurement Units in Excel 2003
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 -- Kevin Backmann "Annie" wrote: 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 -- Kind regards Ann Shaw |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Measurement Units in Excel 2003
Units are governed by your Regional and Language Options in Control Panel.
I Excel, if you go to FilePage SetupMargins 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 On Tue, 3 Oct 2006 07:36:02 -0700, Annie wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Measurement Units in Excel 2003
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? "Annie" wrote: 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 -- Kind regards Ann Shaw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why no XML in Excel 2003 with Office Standard? | Excel Discussion (Misc queries) | |||
Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I change units of measurement in Excel? | Setting up and Configuration of Excel |