SOLVED

Date not showing slash(/) symbol

%3CLINGO-SUB%20id%3D%22lingo-sub-1479184%22%20slang%3D%22en-US%22%3EDate%20not%20showing%20slash(%2F)%20symbol%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479184%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20currently%20using%20excel%20from%20office%20365%20lifetime%20version%20installed%20in%20pc.%20It%20seems%20that%20when%20I%20type%20a%20date%2C%20for%20example%2001%2F01%2F2020%2C%20it%20will%20register%20as%20'1%2001%202020'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20already%20tried%20deleting%20Microsoft%20office%20registy%20then%20reinstalling.%20Any%20suggestions%20on%20how%20to%20fix%20this%20so%20that%20it%20will%20show%20'01%2F01%2F2020'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScreenshot%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jlapido_0-1592717674573.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199915i6417DA5078FEA3C0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22jlapido_0-1592717674573.png%22%20alt%3D%22jlapido_0-1592717674573.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1479184%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1479292%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20not%20showing%20slash(%2F)%20symbol%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479292%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F705793%22%20target%3D%22_blank%22%3E%40jlapido%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20is%20Windows%20short%20date%20format%3F%3C%2FP%3E%0A%3CP%3EYou%20may%20check%20by%3C%2FP%3E%0A%3CP%3EWin%2BR%20%3CSTRONG%3Econtrol%20international%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1479322%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20not%20showing%20slash(%2F)%20symbol%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479322%22%20slang%3D%22en-US%22%3EHello%20Joseph%2C%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20use%20forward%20slash%20as%20your%20date%20separator%2C%20you%20have%20to%20make%20the%20changes%20on%20your%20laptop%20or%20computer.%20Do%20follow%20the%20steps%20below%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Type%20in%20Control%20Panel%20on%20your%20system%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20Under%20Clock%20and%20Region%2C%20click%20on%20Change%20date%2C%20time%20or%20number%20formats%3CBR%20%2F%3E%3CBR%20%2F%3E3.%20Click%20on%20Additional%20Settings%3CBR%20%2F%3E%3CBR%20%2F%3E4.%20Select%20Date%20tab%3CBR%20%2F%3E%3CBR%20%2F%3E5.%20In%20the%20Date%20Formats%20section%2C%20clear%20what%20you%20have%20there%20and%20type%20in%20dd%2Fmm%2Fyyyy%3CBR%20%2F%3E5.%20Click%20OK%20and%20OK.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20you%20return%20to%20Excel%2C%20all%20the%20date%20with%20d%20mm%20yyyy%20will%20turn%20to%20dd%2Fmm%2Fyyyy%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20let%20me%20know%20how%20it%20pans%20out%20after%20following%20the%20steps%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1479428%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20not%20showing%20slash(%2F)%20symbol%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479428%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20soo%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1479447%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20not%20showing%20slash(%2F)%20symbol%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479447%22%20slang%3D%22en-US%22%3EYou're%20welcome.%20Would%20appreciate%20you%20accept%20as%20the%20Best%20Response%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3C%2FLINGO-BODY%3E
Visitor

Hi everyone,

 

I'm currently using excel from office 365 lifetime version installed in pc. It seems that when I type a date, for example 01/01/2020, it will register as '1 01 2020'.

 

I have already tried deleting Microsoft office registy then reinstalling. Any suggestions on how to fix this so that it will show '01/01/2020'

 

Screenshot below.

jlapido_0-1592717674573.png

 

 

 

4 Replies

@jlapido 

What is Windows short date format?

You may check by

Win+R control international

best response confirmed by jlapido (Visitor)
Solution
Hello Joseph,

To use forward slash as your date separator, you have to make the changes on your laptop or computer. Do follow the steps below:

1. Type in Control Panel on your system
2. Under Clock and Region, click on Change date, time or number formats
3. Click on Additional Settings
4. Select Date tab
5. In the Date Formats section, clear what you have there and type in dd/mm/yyyy
5. Click OK and OK.

When you return to Excel, all the date with d mm yyyy will turn to dd/mm/yyyy


Do let me know how it pans out after following the steps

@Abiola1 

 

Thank you soo much.

 

 

You're welcome. Would appreciate you accept as the Best Response

Cheers