Excel 97 - Metric Margin sizes

[Phillip Armitage]

I've a user working on a set of Excel spreadsheets. She's using Excel 97.

When she opens one of these spreadsheets and goes to Page Setup - Margins,
the dimensions that are being displayed appear to be in Centimeters. If the
same file is opened on another computer with Excel 97, the margin dimensions
are given in inches. eg. her left margin setting is 3. When I open it, the
margin is 1.18.

I can't find anywhere in Excel 97 where you can specify the units to use
when entering margin dimensions. In Word 97, you go to Tools - Options, then
the General tab and there is an option to specify the units to use when
formating a document. Anyone know where the equivalent setting can be found
in Excel 97?

I look forward to your response.

 

[Norman Harker]

Hi Phillip!

You change this setting under Regional Settings:

Start > Control Panel > Regional and Language Options
Under the Numbers Tab you can change from US to Metric
Apply


There might be variations in route depending upon your operating
system.