|
Metric to imperial measurements
Could someone tell me how to change my default measurements from metric to
imperial in Excel 2003? I can't work in centimetres! -- Gill |
Look at the CONVERT function in Help.
-- HTH RP (remove nothere from the email address if mailing direct) "Gill.star" wrote in message ... Could someone tell me how to change my default measurements from metric to imperial in Excel 2003? I can't work in centimetres! -- Gill |
I already looked at Convert. This doesn't actually change the defaults. I
want my margin settings, for instance, to be in inches rather than cm. Thanks for your reply though. Gill "Bob Phillips" wrote: Look at the CONVERT function in Help. -- HTH RP (remove nothere from the email address if mailing direct) "Gill.star" wrote in message ... Could someone tell me how to change my default measurements from metric to imperial in Excel 2003? I can't work in centimetres! -- Gill |
Gill
This is a Windows OS setting, not an Excel setting. You would go to Windows Control PanelRegional and Language OptionsRegional Options tabCustomize and set the "measurement system" to Metric. This option will affect all programs. Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:03:04 -0800, Gill.star wrote: I already looked at Convert. This doesn't actually change the defaults. I want my margin settings, for instance, to be in inches rather than cm. Thanks for your reply though. Gill "Bob Phillips" wrote: Look at the CONVERT function in Help. -- HTH RP (remove nothere from the email address if mailing direct) "Gill.star" wrote in message ... Could someone tell me how to change my default measurements from metric to imperial in Excel 2003? I can't work in centimetres! -- Gill |
Thanks. This only gives me the option of "Metric" or "US" - not sure which is
the lesser of the two evils! I rather hoped that Excel would have a setting like Word has, where you can change the default just for that program. It seems it hasn't. Thanks anyway. Gill "Gord Dibben" wrote: Gill This is a Windows OS setting, not an Excel setting. You would go to Windows Control PanelRegional and Language OptionsRegional Options tabCustomize and set the "measurement system" to Metric. This option will affect all programs. Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:03:04 -0800, Gill.star wrote: I already looked at Convert. This doesn't actually change the defaults. I want my margin settings, for instance, to be in inches rather than cm. Thanks for your reply though. Gill "Bob Phillips" wrote: Look at the CONVERT function in Help. -- HTH RP (remove nothere from the email address if mailing direct) "Gill.star" wrote in message ... Could someone tell me how to change my default measurements from metric to imperial in Excel 2003? I can't work in centimetres! -- Gill |
Gill
Sorry, should have read set to "inches". U.S. settings are inches. Isn't that what you wanted? Gord On Sun, 6 Mar 2005 12:01:05 -0800, Gill.star wrote: Thanks. This only gives me the option of "Metric" or "US" - not sure which is the lesser of the two evils! I rather hoped that Excel would have a setting like Word has, where you can change the default just for that program. It seems it hasn't. Thanks anyway. Gill "Gord Dibben" wrote: Gill This is a Windows OS setting, not an Excel setting. You would go to Windows Control PanelRegional and Language OptionsRegional Options tabCustomize and set the "measurement system" to Metric. This option will affect all programs. Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:03:04 -0800, Gill.star wrote: I already looked at Convert. This doesn't actually change the defaults. I want my margin settings, for instance, to be in inches rather than cm. Thanks for your reply though. Gill "Bob Phillips" wrote: Look at the CONVERT function in Help. -- HTH RP (remove nothere from the email address if mailing direct) "Gill.star" wrote in message ... Could someone tell me how to change my default measurements from metric to imperial in Excel 2003? I can't work in centimetres! -- Gill |
Yes, inches is what I want, but won't I get the other US settings as well,
such as letter paper size rather than A4? Gill "Gord Dibben" wrote: Gill Sorry, should have read set to "inches". U.S. settings are inches. Isn't that what you wanted? Gord On Sun, 6 Mar 2005 12:01:05 -0800, Gill.star wrote: Thanks. This only gives me the option of "Metric" or "US" - not sure which is the lesser of the two evils! I rather hoped that Excel would have a setting like Word has, where you can change the default just for that program. It seems it hasn't. Thanks anyway. Gill "Gord Dibben" wrote: Gill This is a Windows OS setting, not an Excel setting. You would go to Windows Control PanelRegional and Language OptionsRegional Options tabCustomize and set the "measurement system" to Metric. This option will affect all programs. Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:03:04 -0800, Gill.star wrote: I already looked at Convert. This doesn't actually change the defaults. I want my margin settings, for instance, to be in inches rather than cm. Thanks for your reply though. Gill "Bob Phillips" wrote: Look at the CONVERT function in Help. -- HTH RP (remove nothere from the email address if mailing direct) "Gill.star" wrote in message ... Could someone tell me how to change my default measurements from metric to imperial in Excel 2003? I can't work in centimetres! -- Gill |
I'm set for U.S. measurement but I still have the A4 size option in the "Paper
Size" dialog box, along with a dozen or more others. Gord On Sun, 6 Mar 2005 17:33:03 -0800, Gill.star wrote: Yes, inches is what I want, but won't I get the other US settings as well, such as letter paper size rather than A4? Gill "Gord Dibben" wrote: Gill Sorry, should have read set to "inches". U.S. settings are inches. Isn't that what you wanted? Gord On Sun, 6 Mar 2005 12:01:05 -0800, Gill.star wrote: Thanks. This only gives me the option of "Metric" or "US" - not sure which is the lesser of the two evils! I rather hoped that Excel would have a setting like Word has, where you can change the default just for that program. It seems it hasn't. Thanks anyway. Gill "Gord Dibben" wrote: Gill This is a Windows OS setting, not an Excel setting. You would go to Windows Control PanelRegional and Language OptionsRegional Options tabCustomize and set the "measurement system" to Metric. This option will affect all programs. Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:03:04 -0800, Gill.star wrote: I already looked at Convert. This doesn't actually change the defaults. I want my margin settings, for instance, to be in inches rather than cm. Thanks for your reply though. Gill "Bob Phillips" wrote: Look at the CONVERT function in Help. -- HTH RP (remove nothere from the email address if mailing direct) "Gill.star" wrote in message ... Could someone tell me how to change my default measurements from metric to imperial in Excel 2003? I can't work in centimetres! -- Gill |
| All times are GMT +1. The time now is 08:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com