Fveng
asked on
Excel 2010 - Cannot set dates to use forward slashes
One of our users on Windows 8.1 using Excel 2010 is not able to change the date formatting in an existing Excel spreadsheet. His date format defaults to using commas, and I cannot set it to use forward slashes. I have tried changing to a different language within Excel, and back to English US with no resolution. (Please see attached screen shot) I have the same operating system and also have Excel 2010, and the same spreadsheet opens fine on my machine with the dates showing up as they should with the forward slashes.
I'm guessing there is a simple setting somewhere in Excel to fix this. Any help would be appreciated!
Thank you.
comma-dates.png
I'm guessing there is a simple setting somewhere in Excel to fix this. Any help would be appreciated!
Thank you.
comma-dates.png
Try to use Custom Formatting with mm/dd/yyyy and see if this works for you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Rob! That was it. User is a happy camper now.
His date format defaults to using commas, and I cannot set it to use forward slashes.
Because of your above statement, I thought that you are not allowed to change the regional date settings that's why I offered you that solution.
I think Rob guessed you correctly.