Thread: Metric Settings
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.newusers
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Metric Settings

Just one more thought Felix. Are you sure the display isn't
fooling you. In my display boxes the values don't show
their actual designation, they just show 2.5 (not 2.5cm)
If I change my measurement to U.S. it will show as 0.98425
(not 0.98425").

A longshot I know but I have been caught out by
that sort of thing more times than I care to admit.<g

Regards
Martin



"MartinW" wrote in message
...
Hi Felix,

I can't replicate that behaviour here. (Windows XP and Excel 2000.)

My Excel settings stay linked to the Windows settings and Excel
has no option (or need) to use anything else. My page margins
and image size values etc. adjust with those Windows settings
with no need for a restart when changing them.

Maybe 2003 is different, however, I haven't heard of anything
like that.

All I can suggest is to go through every Tab in ToolsOptions
very closely.

Sorry I can't help you further,
Martin


"Felix" wrote in message
...
Thank you for taking the time.

My problem is the following:

My Powerpoint 2oo3 has metric settings for page margins (Centimetres)
My Word 2oo3 has metric settings for page margins (Millimetres)
My Excel 2oo3 has these settings in inches

I would like to have all settings in metric (mm or cm).

I my Windows 2ooo, Control Panel Regional Options Numbers
Measurement
System is set to "Metric"

Yet Excel is still in inches ...
--

Felix


"MartinW" wrote:

Please explain in detail exactly what settings and measurements
you are talking about.

Regards
Martin



"Felix" wrote in message
...
It did not change: Do I have to restart?

The interesting thing is that in Word it is metric and in Excel in
inches....
--
Felix


"Gord Dibben" wrote:

Just a note to Martin's suggestion..................

This will affect all Application settings, not just Excel.


Gord Dibben MS Excel MVP


On Sun, 23 Sep 2007 01:05:53 +1000, "MartinW"
wrote:

Hi Felix,

I think the settings you are after are actually Windows settings.
Things like image size etc.

You can access them at StartSettingsControl PanelRegional and
Language
Options
Under the Regional Options tab click on customize and choose metric
for
the
measurement system.
Make sure you click the Apply buttons before you OK out.

These instructions are for Windows XP. If you are using a different
OS
then
there may be
some minor differences but the basics should be the same.

HTH
Martin


"Felix" wrote in message
...
Sorry, I wasn´t specific:

I want to change fronm inches to mm in the settings of Excel as
default
--
Felix


"Gary''s Student" wrote:

=CONVERT(A1,"in","mm") for mm

--
Gary''s Student - gsnu200746


"Felix" wrote:

How to change from inches to mm in Excel?
--
Felix