hard20 pts · first answer countsexceldatesdata-import

Dates swapped when opening a CSV

A CSV from an Indian system has dates in DD/MM/YYYY. On a laptop set to US format, 03/04/2026 shows as 4 March, and 25/04/2026 stays as left-aligned text. What is the right fix?

A.Change the column format to Date right after openingB.Sort the column so the dates line up againC.Import with Power Query or the text wizard set to DMYD.Use =VALUE() on every date in the column

Discussion 0

Join free to post in the discussion.

Dates swapped when opening a CSV

Discussion 0

Related questions