Excel, want to change date format from us to uk, for old data.
 

Hello, I hope someone can help me. I have just started with a company that
has kept their financials on excel and lists the date in UK format. I am
changing the company dates over to US. Can this be done automatically by the
program.
Thank you.
MS

Excel, want to change date format from us to uk, for old data.
 

As long as they are real Excel dates, not text, no problem. Just format US
and they'll show US dates.

--
Kind regards,

Niek Otten

"Santa" wrote in message
...
Hello, I hope someone can help me. I have just started with a company that
has kept their financials on excel and lists the date in UK format. I am
changing the company dates over to US. Can this be done automatically by
the
program.
Thank you.
MS