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 Key Date Format

I am trying to use the ctrl+; to enter the current date in d mmm format. I
can get a dd-mm-yyyy in the data entry box at the top of the screen but not
d mmm in the cell.

I tried using one of the "*" date formats plus regional settings but that
didn't work.

Any suggestions?

TIA