how do I convert English (Canadian) dates to English (US) dates

[dinertx]

downloaded from network report Canadian dates dd/mm/yyyy format and need to
convert to US dates mm/dd/yy....

 

[Mike H]

Try

Format|Cells|Custom
enter a Custom formula of

mm/dd/yyyy

Mike