Troll/Idiot wrote:
Johnny Rosenberg wrote:
2007/12/18, Phyllis Corella <[EMAIL PROTECTED]>:
I am having a problem with the date cell. When I enter 10-13-2007 it
automatically puts in 13-10-2007. Now, since I am not in Europe I
would
like to be able to have the format that is used in the United States
be the
one that I want. I tried your help index, but I did not see it
there. Can
you walk me through it? thanks.
Phyllis Corella
Hm... what's wrong with the international ISO8601 date format?
2007-10-13.
By the way, that's my birthday...
J.R.
I prefer dates in that format or something similar (071013) since they
make files sort in a convenient order, but some people seem to find
them almost incomprehensible. It's like you're asking them to look
for the morning sun in the west.
Happy birthday.
Hello Phyllis,
I would do two things.
First, from your OpenOffice.org menu
TOOLS > OPTIONS > Language Settings > Languages
For "Locale Setting" change this to 'English ( USA )'
Close the options dialog
Next, inside your Calc file. Highlight the column, or group of cells
with dates. Right mouse click and select "Format Cells"
Select 'Date' under Categories.
In the text box "Format code" enter MM-DD-YYYY
Click on the green checkmark to the right of this, close the dialog.
That should give you what you want, how you want it.
Drew
ps
Happy Birthday from me too...
and
Come one guys these are Personal Computers not ISO
computers...*chuckling*..although I agree with the sorting comment, IF
you are treating the data as text, if it is actually treated as dates
then it makes no difference, the column sorts properly no matter what
display you choose, does it not?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
