Change date from UK to US for one spreadsheet
d/m/y is US format.
It shouldn't matter, Excel should manage it unless they are text.
--
---
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?
|