View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel L. Lieberman Daniel L. Lieberman is offline
external usenet poster
 
Posts: 11
Default Shortcut Date entry problem

Sorry it doesn't work. The problem appears to have started in the keyboard
shortcut Ctrl + ; The regional settings are correct but while the date is
proper there the formatting in Excel doesn't work.

"Teethless mama" wrote in message
...
Right click Format cells Custom d mmm


"Daniel L. Lieberman" wrote:

In the past by using ctrl+; I have been able to, using formatted cells
show
e.go. 14 Mar. All of a sudden I cannot. What I get is 14-03-2007.

My short date is set in Regional Settings as dMMMyy.

Vista Business and Excel 2007.

TIA