[OT] OpenOffice calc question

[Matthew Gillen]

Jerry Feldman wrote:
> My company's product uses dates in yyyymmdd format, but can import csv
> files directly from any spreadsheet. If I import a csv containing
> yyyymmdd, OO calc correctly displays the date, but if I want to modify
> the spreadsheet (mainly financial curves), it outputs the date in the
> mmddyyyy or mmddyy in the resultant csv. Does anyone know how I can
> tell OO to output dates in the desired format preferably without
> changing the entire locale. Of course, the csv can be edited with emacs
> (or lesser capable editors like vi :-). 

Go to Format->Cells... and select the "Numbers" tab.  Then look for the "Date"
field in the left-most combo box, and you should be able to take it from there...

HTH,
Matt

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.