ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel displaying inches not cm (https://www.excelbanter.com/excel-discussion-misc-queries/263894-excel-displaying-inches-not-cm.html)

Adam

Excel displaying inches not cm
 
Having a problem with Excel recently (last week or so) whereby the "format
Picture" option is displaying the measurements in inches, despite the OS
Regional Setting of Metric.

1) I have switched the regional setting from Metric to US, then back to
Metric, which fixes the problem, but it then reverts to inches when I reopen
excel
2) Only affecting Excel, not Word etc.
3) Only affecting the Format Picture option, the margins and page sizes are
still displaying in cm/mm
4) Excel 2003, on WinXP

Any help would be greatly appreciated.


All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com