![]() ![]() Why won’t the imported dates change format? Why won't they show a short date, without time included, in the cell's formatting? ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |