Excel ignoring date format when saving to Text

[MattLemon]

Hi,

I have a spreadsheet that look fine on the screen, perfectly formatted
date wise. It's a 2003 SP2 spreadsheet. When I save it to text (Tab
delimited) or any other text format it reverts to mm/dd/yyyy formating
instead of british dd/mm/yyyy.

I've checked all the regional settings on the machine and nothing
appears to be wrong with it. Prior to an upgrade to 2003 it was
working fine. I tried installing excel 2000 aswell but now that
doesn't work either.

Any help appreciated.

Thanks,

Matt

 

[Jim Rech]

I switched to UK setting from US and started Excel 2003. I pressed Ctrl-;
to get today's date in cell A1 and it appeared as 13/05/2008. I saved to
"Text (tab delimited)" format and the date appeared exactly the same in the
text file. What did I do wrong?

--
Jim
| Hi,
|
| I have a spreadsheet that look fine on the screen, perfectly formatted
| date wise. It's a 2003 SP2 spreadsheet. When I save it to text (Tab
| delimited) or any other text format it reverts to mm/dd/yyyy formating
| instead of british dd/mm/yyyy.
|
| I've checked all the regional settings on the machine and nothing
| appears to be wrong with it. Prior to an upgrade to 2003 it was
| working fine. I tried installing excel 2000 aswell but now that
| doesn't work either.
|
| Any help appreciated.
|
| Thanks,
|
| Matt