Slashes suddenly missing from default dates after upgrade to Windows 10

JenLL

New Member
Joined
Feb 26, 2016
Messages
3
Hello! We recently upgraded from Windows 7 to Windows 10, using our old copy of MS Office 2010. I have noticed that all the spreadsheets I have suddenly had slashes missing. So 5/16/16 now reads as 5 16 16.

So, I looked at the number formats, and it looks like the slash has been completely eradicated from all date formats.

Now, I'm dyslexic, and I literally cannot read the dates correctly without being parsed by the slash, or something similar. So:

1. Does anyone know a way to restore the slashes?
2. If not, does anyone know how to tell Excel to accept a custom date format at the default date format?

Thank you!
 

thisoldman

Well-known Member
Joined
Jan 5, 2014
Messages
1,073
Does this happen only with Excel? Are dates in other programs affected? Can you type the forward slash alone in an Excel cell and have it display properly?

Perhaps it's the Windows short date setting? You can check:

Go to the Control Panel—right click on the Start button (the Windows logo). Select Control Panel. In the Control Panel, under "Clock, Language, and Region," select "Change date, time, or number formats." A dialog box should pop up where you can change the "Short date" format.
 
Last edited:

JenLL

New Member
Joined
Feb 26, 2016
Messages
3
Thank you for getting back to me!

1. Yes, it's only in Excel. The windows short date setting is displaying slashes correctly, and when I go into Word to input a date field, the date fields with slashes are correct.

2. I was having a problem with not being able to type a slash in Excel, but I went into Options, Advanced, and removed the slash as the Microsoft Excel Menu Key under Lotus Compatibility, and now that problem has been corrected. I have tried leaving that field blank, and putting in a different key, neither of these things has corrected the missing slashes from the excel numbers formats.
 

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
3,780
a) Access Format Cells shortcut Crtl+1 then Numbers then Date
At the bottom of that screen is a Locale (Location) drop down. Check if one of the countries has a format that you require.

and/or

b) Check your regional settings in Windows Control Panel and change to a country with the format that you require.

and/or

c) With a blank workbook, create a cell formatting style with the formatting that you prefer and save the workbook as a template. Use this template for future workbooks.
 
Last edited:

JenLL

New Member
Joined
Feb 26, 2016
Messages
3
a) Doesn't quite work. All slashes are absent from all time displays. Looks like the best I can do is Albanian, which does yy-mm-dd.

b) Doesn't work. While date displays in Word are obviously tied to the date format set for Windows, there does not seem to be a similar correlation in Excel.

c) Yeah, I think I'm going with this. Thank you. :)

I'm not going to say this is the WEIRDEST thing I've seen Excel do, but it's definitely up in the top twenty. I think the weirdest thing is that the dates don't even display slashes in the formula bar. Once we're completely done with the upgrade, I might run a repair/reinstall just to see if that fixes things.
 

Forum statistics

Threads
1,082,115
Messages
5,363,247
Members
400,722
Latest member
DrewPop24

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top