Monday, April 12, 2010

Mobile Excel Date formatting wrong?

For some reason Pocket Excel on my HP Ipaq rx3950 (running WM5) has started thinking it is on the US and is formatting the date in the mm/dd/yy format.





My regional setting are set to UK (date is dd/MM/yy)


Cell format is also dd/MM/yy





What used to happen was that I would enter a date, eg 2/4 and this was


correctly interpreted at


2-Apr-07





Now, my PPC interprets the date as


4-Feb-07 (ie US date format)





How do I get Pocket Excel to go back to thinking European and not US?





I also checked the registy and [HKEY_LOCAL_MACHINE\nls\overrides] "SSDte" is


set to 'dd MMM yy'

Mobile Excel Date formatting wrong?
Hard Reboot?
Reply:A rather drastic solution I feel! Report It


crowns

No comments:

Post a Comment