Skip to main content
Back to homepage →

Can you add a date format for users living outside of the US? - Knowledgebase / Calc XLS - Mariner Software

Can you add a date format for users living outside of the US?

Authors list

Yes, we can, it will be a "custom format". The xls file format has several data formats that are standard and the rest are all written in the file as custom. If you go into Excel, the date formats look like:

 

*3/14/01

*Wednesday, March 14, 01

3/14

3/14/01

03/14/01

14-Mar

14-Mar-01

14-Mar-01

Mar-01

March 14, 2001

3/14/01 1:30 PM

3/14/01 13:30

M

M-01

3/14/2001

14-Mar-2001

 

All the other formats are custom as:

dd/mm/yy

dd/mm/yyyy

dd-mm-yy

dd-mm-yyyy

 

Calc XLS has the facility to read, parse and display these custom formats from imported files. Calc XLS doesn't yet have the ability to set/write those custom formats. We should add a "Custom" format in a future release.

Helpful Unhelpful

13 of 16 people found this page helpful