Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 78
Default Metric Settings

How to change from inches to mm in Excel?
--
Felix
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,058
Default Metric Settings

=CONVERT(A1,"in","cm")
--
Gary''s Student - gsnu200746


"Felix" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,058
Default Metric Settings

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

--
Gary''s Student - gsnu200746


"Felix" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 78
Default Metric Settings

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

  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 860
Default Metric Settings

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





  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default Metric Settings

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



  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 78
Default Metric Settings

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




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
Converting Metric to Imperial Seb Excel Worksheet Functions 7 September 21st 07 09:06 AM
Converting 00:15:00 format into metric The Rook Excel Discussion (Misc queries) 1 February 9th 07 10:34 AM
change imperial to metric Kangarule Excel Discussion (Misc queries) 3 September 17th 06 05:41 PM
function to change metric measurements devo Excel Worksheet Functions 5 July 7th 06 11:05 AM
Metric to imperial measurements Gill.star Excel Discussion (Misc queries) 7 March 7th 05 01:57 AM


All times are GMT +1. The time now is 11:14 PM.

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

About Us

"It's about Microsoft Excel"