Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why no XML in Excel 2003 with Office Standard? [email protected] Excel Discussion (Misc queries) 0 April 21st 06 10:36 PM
Merging cells in Excel 2003 Bob Excel Discussion (Misc queries) 1 October 19th 05 07:10 PM
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. Juan Angel Excel Discussion (Misc queries) 1 June 21st 05 09:55 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM
How do I change units of measurement in Excel? Gramps Setting up and Configuration of Excel 1 January 9th 05 08:37 PM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"