View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam Adam is offline
external usenet poster
 
Posts: 287
Default 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.