Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[OT] OpenOffice calc question

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...


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

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /