Forum Discussion
jlapido
Jun 21, 2020Copper Contributor
Date not showing slash(/) symbol
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 alre...
- Jun 21, 2020Hello 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
SergeiBaklan
Jun 21, 2020Diamond Contributor