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

S

Santa

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
 
N

Niek Otten

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