Shortcut Key Date Format

  • Thread starter Thread starter Daniel L. Lieberman
  • Start date Start date
D

Daniel L. Lieberman

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
 
When you go into the Format Cell dialog box, select Custom from the Category
list and then enter the format you posted (that you want) into the Type
field.

Rick
 
Rick,

That is what I have done but the custom formatting is not being applied for
some reason.

Thanks for trying.

Daniel
 
Back
Top