View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Cant get dd/mm date format in Excel 2003

Ah, yes. I see the CTRL + ` in the list, and I see what it does.

On my keyboard, the tilde is obtained from SHIFT + #. The page which I
quoted
(http://office.microsoft.com/en-us/ex...CH010503701033) shows different functions for CTRL + ~, CTRL + #, and CTRL + `, and each ofthem agrees with what I get on my keyboard.--David Biddulph"Gord Dibben" <gorddibbATshawDOTca wrote in messagenews:0v0373d8vi1a96v8bir74rk8nfqtc2f824@4ax .com... David CTRL + `(backquote) toggles view formulas on/off. Since the tilde is on same key G's S used CTRL + ~ Gord Dibben MS Excel MVP On Thu, 14 Jun 2007 17:49:25 +0100, "David Biddulph" <groups [at] biddulph.org.uk wrote:Which version of Excel?For 2003 the shortcuts are described athttp://office.microsoft.com/en-us/ex...037811033.aspx, but there maybe some confusion on keyboard layout, such as which characters need theshift key.http://office.microsoft.com/en-us/excel/HP011116591033.aspx?pid=CH010503701033shows the list differently, but still no sign of the toggling effect towhich you refer.Interesting!