Excel convert date format

nononame2021 256

My date format is now 01-Oct-2024, how can i use excel formula to change to 01/10/2024 dd/mm/2024

1 answer

Brendan Walker 0 Reputation points

2024-10-25T12:23:02.3833333+00:00
Using the TEXT Function

If your date is in cell A1, you can use the TEXT function to format it directly in another cell.

=TEXT(A1, "dd/mm/yyyy")

Alternatively, if you want to change the display format without using a formula:

Select the cell(s) containing your date (e.g., 01-Oct-2024). Press Ctrl + 1 to open the Format Cells dialog. In the Number tab, select Custom and enter the format dd/mm/yyyy. Click OK to apply the format.
Please sign in to rate this answer.
nononame2021 256 Reputation points

2024-10-27T14:47:05.0833333+00:00

I have tried, but the text hasn't changed even I already add the formula to the cell.

Barry Schwarz 3,071 Reputation points

2024-10-28T00:30:24.27+00:00

You cannot change the text of a cell by adding a formula to that cell.

You have asked this question multiple times and apparently don't like any of the answers. Give us some details:

Show us the contents of the cell with the format set to number.

Show us the formula you entered in the cell where you want to see the value reformatted.

Tell us why the result is not what you wanted.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer