Forum Discussion
Date format
How do i change format of this date 01 11 2025 to 01/11/25?
m_tarler makes an important point by distinguishing between converting text into a real Excel date and simply changing how the date is displayed.
For your specific example, once Excel recognizes 01 11 2025 as a date, press Ctrl + 1, select Custom, and enter dd/mm/yy. The result will be 01/11/25.
If Excel treats the original value as text, convert it first using Data > Text to Columns, selecting Date: DMY to ensure it is interpreted correctly as 1 November 2025.