[PLUG] Re-formatting Date in .csv Field

[Rich Shepard]

On Tue, 25 Jan 2011, wes wrote:

> Do I interpret this correctly to mean that OOo will display the date in
> the format you want, but will not save it to disk in that format?

Wes,

   Yup.

> Maybe try copy/paste into a new spreadsheet?

   It's a view thing, does nothing to the underlying string/numbers.

> I'm a lazy cheater. I would change the field separator to some character
> that is not found in the file already: sed s/","/"%"/

   That's a good thought, Wes.
> then work the other magic that has been offered already.

Rich