bskinn / excel-csvexporter

Lightweight tool to export ranges within an Excel sheet to CSV
MIT License
41 stars 7 forks source link

Formatting dates #34

Closed Mastomaki closed 2 years ago

Mastomaki commented 3 years ago

Formatting of dates needs improvement. For example

Excel

1.1.2018 0:00 1.1.2018 1:00

CSV

1.1.2018 1.1.2018 1.00.00

bskinn commented 3 years ago

Are you just using the default @ formatting code?

Mastomaki commented 3 years ago

Yes. How would you suggest to change it?

bskinn commented 3 years ago

One example of a date/time format is: mm/dd/yyyy hh:mmAM/PM.

If you don't want leading zeros on the month, day or hour, use m or d or h instead of mm/dd/hh.

If you only want a two-digit year, use yy.

If you'd prefer a 24-hour time instead of an AM/PM time, remove the AM/PM.