How to Change Date/Time Format for whole column

Natasha1993 

Format a date the way you want

You can easily update the date/time format for a whole column in Excel 365.

Here is how you can do it:

1. Select the entire column containing the date/time values. You can click on the column header to select the entire column.
2. Right-click on the selected column and choose "Format Cells" from the context menu. Alternatively, you can use the keyboard shortcut Ctrl + 1.
3. In the "Format Cells" dialog box, go to the "Number" tab.
4. In the Category list, select "Custom" or "Date" (depending on your preference).
5. In the "Type" field, enter the desired date/time format. For DD/MM/YYYY HH:MM, you can use the following format: dd/mm/yyyy hh:mm.
6. Click "OK" to apply the new format to the selected column.

After following these steps, the entire column will be updated to display the date/time values in the format you specified. Excel will recognize the format and display it accordingly, regardless of the default regional settings on your PC.

Please note that changing the format of the column does not modify the underlying values. It only changes how the values are displayed. If you need to convert the values to a different format or adjust the actual date/time values, you may need to use formulas or other techniques specific to your data. The text was created with the help of AI, the link is from Microsoft.