Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> StarOffice >> StarSuite

Saving chosen date format in csv-file

I format all cells in one column to a dateformat dd-mmm-yy

i.e. 01-jan-06, works fine I have all the dates in the year by clicking on first cell.

BUT I can not SAVE the file as csv keeping the format - it is saved as 01-01-2006, which I can not use.

I do this in Excel all the time - do I have to do something special in Staroffice Calc 8.0 ?

[416 byte] By [] at [2007-11-25 22:32:31]
«« embeddeded image problems
»» lookup in different spreadsheet
# 1

The problem in short is:

I have a column with dates:

01-jan-06

02-jan-06

...

30-dec-06

31-dec-06

as I have defined this format in "format-cells-user defined"

when I save this in .csv format the column comes out as:

01-01-2006

02-01-2006

...

How do I save to show the intended:

01-jan-06

02-jan-06

...

30-dec-06

31-dec-06?

at 2007-7-5 2:47:09 > top of Java-index,StarOffice,StarSuite...
# 2
Try this:>choose date cell(s)>right click>format cells>numbers > choose: text..The reason behind your problem is local settings. Another way to get rid of this problem is to change those settings...
Tan2000 at 2007-7-5 2:47:09 > top of Java-index,StarOffice,StarSuite...
StarSuite

StarOffice New Topic

StarOffice Hot Topic

StarOffice

All Classified