![]() ![]() Those dates stay in the same date/time format, no matter how you try to format cells that contain those dates. However, the date format for the imported dates in column C does not change.Using the Number format commands on the Excel Ribbon Home tab, the Short Date format has been applied, from the number format menu. ![]() The time shows hour, minute and second = hh:mm:ss with AM or PM. The date is in short date format - d/m/yyyy. In the screen shot below, Column C contains imported dates, which show the date and time, separated by a space character. There are written steps below the video, and to follow along with the steps in this video, download the sample Excel Dates Fix Format workbook. ![]() This video shows how to fix the dates that won't change format, with a few simple steps. If you import data into a Microsoft Excel spreadsheet, and try to format a column of dates, sometimes the dates will not change format. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |