Date Format

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?

Paul Newcome

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)