SOLVED

date column formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1092718%22%20slang%3D%22en-US%22%3Edate%20column%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1092718%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20list%20dates%20in%20random%20order%20in%20a%20left%20column%20on%20a%20sheet%20of%20expenses.%20Never%20had%20a%20problem%20previously%2C%20but%20having%20upgraded%20my%20system%20with%20a%20new%20computer%20and%20latest%20Excel%20worksheet%2C%20my%20dates%20now%20show%20only%20the%20month%20and%20year%2C%20but%20not%20the%20day.%20My%20previous%20version%20of%20Excel%20allowed%20me%20to%20show%20dates%20as%20follows%3A%20Dec%205%2C%20Dec%2012%2C%20etc......%20but%20now%20all%20I%20can%20show%20is%20December%202019%20without%20the%20specific%20date.%20How%20do%20I%20only%20show%20the%20month%20and%20date%20without%20the%20year%2C%20independendly%20of%20any%20formula%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1092718%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1092732%22%20slang%3D%22en-US%22%3ERe%3A%20date%20column%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1092732%22%20slang%3D%22en-US%22%3ENumber%20Format%20%26gt%3B%20Date%20or%20Number%20Format%20%26gt%3B%20Custom.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2030887%22%20slang%3D%22en-US%22%3ERe%3A%20date%20column%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2030887%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F508076%22%20target%3D%22_blank%22%3E%40blair_mcrobie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20u%20find%20a%20solution%3F%20Also%20have%20a%20new%20computer%20now%20my%20date%20inputs%20gone%20crazy.%20I%20enter%20like%2015.05.2020%20and%20I%20get%2015.5.20%20or%2015.5.2020%20both%20formats%20in%20the%20same%20sheet.%20I%20want%20to%20change%20a%20date%20it%20jumps%20to%20american%20input%205%2F15%2F20%20-%20quite%20anoying.%20If%20you%20got%20any%20idea%20what%20this%20is%20I%20would%20appreciate.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2032067%22%20slang%3D%22en-US%22%3ERe%3A%20date%20column%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2032067%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401100%22%20target%3D%22_blank%22%3E%40Dietmar5%3C%2FA%3E%26nbsp%3BIt%20looks%20like%20you%20need%20to%20change%20regional%20and%20date%20format%20settings%20for%20your%20new%20computer.%3C%2FP%3E%0A%3CP%3EWin%2BR%3C%2FP%3E%0A%3CP%3Econtrol%20international%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eand%20here%20check%20both%20Format%20and%20Administrative%20tabs.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I want to list dates in random order in a left column on a sheet of expenses. Never had a problem previously, but having upgraded my system with a new computer and latest Excel worksheet, my dates now show only the month and year, but not the day. My previous version of Excel allowed me to show dates as follows: Dec 5, Dec 12, etc...... but now all I can show is December 2019 without the specific date. How do I only show the month and date without the year, independendly of any formula?

3 Replies
Best Response confirmed by blair_mcrobie (Occasional Visitor)
Solution
Number Format > Date or Number Format > Custom.

@blair_mcrobie 

Did u find a solution? Also have a new computer now my date inputs gone crazy. I enter like 15.05.2020 and I get 15.5.20 or 15.5.2020 both formats in the same sheet. I want to change a date it jumps to american input 5/15/20 - quite anoying. If you got any idea what this is I would appreciate.

@Dietmar5 It looks like you need to change regional and date format settings for your new computer.

Win+R

control international

 

and here check both Format and Administrative tabs.