[WelMac] Fwd: Date formats are US MM/DD in Excel etc despite System Prefs.

[Jo Booth]

FYI.  I'm sure other people have the same problem :)
Excuse the Top Posting

Begin forwarded message:

> Aha. Solved. I selected NZ but didn’t know what unicode was. All  
> sorted...for now. :)
>
> -Deb
>
>
>
> From: Jo
> Date: Fri, 21 Oct 2005 14:13:52 +1300
> To: Deb
> Subject: Re: Date format
>
> Make sure you have a real region set and saved in international  
> prefs - say Australia.  Quit word / excel and change the Region so  
> it doesn't say "This region can only be used by Unicode  
> applications..." close prefs and open them to tweak as needed for  
> NZ...
>
> Also check your date/time formats are the same -- set to a safe  
> Format and save and then change. If you change straight from US to  
> NZ formats -- it uses US for Word and Excel - cause they don't do  
> unicode..
>
> Hope that helps.
> -Jo.
>
>  On 19/10/2005, at 08:14 , Deborah Shortt wrote:
>
>> Hello there
>>
>>  My computer is changing all the dates in excel to american month/ 
>> day rather than day/month
>>  Even if the format of the cell is correct. Did you have this  
>> problem?
>>
>>  Ta.
>>

-- 
Joseph Booth
Senior Diagnostic Technician
Airlab
Tel +64 4 472 2207 | Mob +64 21 645 102 | Fax +64 4 472 2208
Unit 9, 2 Tyers Rd, Ngauranga, P O Box 38333, WMC, Wellington, New  
Zealand
Visit us www.airlab.co.nz