3
I have column A with date "dd/mm/yy" in a CSV file, and I need to write it to excel column A with dateformat "dd-mm-yy", is there any action can be performed?
I’m going to give you the logic, you will have to automate it. Best of luck!
Open the csv in excel
Column A should default to date
Write a formula in a blank column, row 2 (assuming you have a title row)
=text(A2,”dd-mm-yy”)
copy the formula down
now you can copy this column and should be able to paste it into column A
if that doesn’t work for whatever reason:
open the csv in excel
select column A
format cells: custom
dd-MM-yyyy
good luck!
Share
Report
All responses (
Answers (
