How to set a default date format for all the office applications?

I have Windows XP on one of my laptops & window 7 on the other. The date format that i’ve set for both is YYYY/MM/DD. Yet when i use LibOff, the format appears in the MM/DD/YYYY format. In spreadsheet, i’ve to select the date format in each column to agree with my chosen format. How to keep a YYYY/MM/DD format across all the applications?

Same problem with me. I have set the default date format as ‘DD-MMM-YYYY’ in Regional Settign of Windows. Yet LO doesnot setitself to that format. I have to set for each column!!

Illegal answer.