Scrub the comment about d/m/y being US format, but the other part is meant.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Lauren" wrote in message
...
Our dates are set to US but I've received a spreadsheet from one of our UK
offices with dates formatted as d/m/y and I need them in US format.

How can I do this on the spreadsheet only?