CODEWITHSUNDEEP
excelcsvdatetime
spaceba
spaceba

Reputation: 113

Column format in excel, yyyy-mm-dd hh:mm:ss

I need to set my column in Excel to yyyy-mm-dd hh:mm:ss. When I open my csv file in VSCode, the format is correct, but when I open it in Excel, the written data in column is yyyy-mm-dd hh:mm. When i click the cell, the format displayed on formula bar was yyyy-mm-dd hh:mm:ss. Does anyone know how to appear the data correctly in the cell? Thank you :/

enter image description here

Upvotes: 0

Views: 4827

Answers (1)

amitklein
amitklein

Reputation: 1395

You can simply enter yyyy-mm-dd hh:mm:ss to the custom option (the one at the buttom).

enter image description here

Upvotes: 3

Related Questions