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



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 :-).=20

--=20
Jerry Feldman <gaf-mNDKBlG2WHs at public.gmane.org>
Boston Linux and Unix user group
http://www.blu.org PGP key id:C5061EA9
PGP Key fingerprint:053C 73EC 3AC1 5C44 3E14 9245 FB00 3ED5 C506 1EA9






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 / webmaster@blu.org