My favorite date format is March 30, 2015
When I click upon date format, I have to dig deeper to find that format. Is there an easier way?
My favorite date format is March 30, 2015
When I click upon date format, I have to dig deeper to find that format. Is there an easier way?
Hello,
Yes there is, in format there is a "Custom" option and enter:
This should be saved so it will be quicker next timePlease Login or Register to view this content.
Adam
Hello Queenofmycastle,
Welcome to the Forum.
jonesa01 is correct, Right click on the Cell, > Format Cells> Custom, and enter mmmm dd, yyyy in the box just below "Type".
And you are good to go!
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Thank you so much! I was hoping for a way to change the standard formats on the dropdown.
Create a Shortcut.
Copy and past the below VBA:
Sub DateFormat()
'
' DateFormat Macro
'
' Keyboard Shortcut: Ctrl+Shift+A
'
Selection.NumberFormat = "[$-409]mmmm d, yyyy;@"
End Sub
Note: Keyboard shortcut is up to you
Now you can enter date in any cell/cells and run macro to get the new format.
Last edited by Shareez Saleem; 06-29-2015 at 03:37 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks