Login to your Excel 365 Online account and open the file.Ģ. We followed the same steps as for Excel 365 Desktop to check the current Excel date format. Change the Date Format in Excel 365 Online However, because the date format was set to read month then day, entering was being entered as a date but it was being held as the 2nd of January, not the 1st of February. Since there isn’t a 31st month, Excel saw this as a mistype and entered the date as text, not a date. For example, was being entered incorrectly because the web version of Excel 365 was seeing the date as mm/dd/yyyy. This was the reason some of the dates were being left-aligned in the column. When team members were editing the sheet in the browser version of Excel (Excel 365 Online) the formatting changed to month/day/year, a.k.a mm/dd/yyyy, even though the date formats were set correctly in Excel 365 Desktop. Tip #2 Change the date format in Excel 365 Online We used the steps in Tip #3 below to reset the dates to the correct format.Īdditionally, as soon as a team member accessed the file using Excel 365 Online the dates went back to being formatted incorrectly. However, even if we clicked OK to reapply the formatting on every selected cell, we still had several cells that were still formatted incorrectly with the date still left-aligned in the column. We found that the date settings were set correctly in Excel 365 Desktop. The team continually battled with dates entered as mm/dd/yyyy when they would normally use the dd/mm/yyyy format.Īdditionally, some dates were aligned to the left of the cell and some to the right and this was happening in both the desktop and web versions of Excel. Sadly, the date formats kept changing when anyone accessing the file using Excel 365 online updated the file. When dates were entered using Excel 365 desktop the date format was correct. Some team members were using both Excel 365 for Desktop when working in the office, and Excel 365 Online when working from home. Our client’s team had a problem with date formatting in Excel 365 Online when some members were updating dates in a shared file in the Desktop version of Excel 365, and others were updating dates in the same file using Excel 365 online, the web browser version. However, it can be super frustrating when data is entered incorrectly as this impacts everyone using the file, and fixing formatting problems can be such a waste of your precious time. Saving files into OneDrive or SharePoint is a fantastic way for team members to be updating and working with files from outside of the office, and an excellent way for everyone to have access to the same file either inside or outside of the office. You may be experiencing problems within your own files, files you share with others, or both. Why is the Excel 365 Online date format not working?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |