Date Format
Options
Angie M Graham
✭✭✭✭
To import data into a program I am using I need the date to be formated as mm/dd/yyyy. Currently I can only find a setting for mm/dd/yy (I did a 4 digit year format). Can this be done?
Answers
-
Try inserting a text/number column and entering
=IF(MONTH([Date Column]@row< 10, "0") + MONTH([Date Column]@row) + "/" + IF(DAY([Date Column]@row)< 10, "0") + DAY([Date Column]@row) + "/" + YEAR([Date Column]@row)
