MarieSpence 

1. Format a date and time field

The date and time data types have a wide variety of formats to help meet your unique circumstances. When formatting you have three choices: keep the default formats, apply a predefined format, or create a custom format. When you apply a format to a table field, that same format is automatically applied to any form or report control that you subsequently bind to that table field. Formatting only changes how the data is displayed and does not affect how the data is stored or how users can enter data.

2. How to change American date format in Excel?

Change date formats with the Format Cells feature

With this Format Cells function, you can quickly change other date formats to America date format.

Change date formats with formula

You can use a formula to convert the date format according to following steps:

1. In a blank cell, input the formula =TEXT(A1, "mm/dd/yyyy"), in this case in cell B1.

Of course there is also the VBA solution, which is not analyzed here.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)