If you use LibreOffice's spreadsheet application Calc, Jack Wallen's answers to a reader's problems with cell and default date formatting might help you, too.
I also have one other question. Though I'm sure it's in the libre preferences somewhere. The date likes to display what it wants rather than what I want. Example: I would like it to say April 11, 2012 but Libre always changes it to 04/11/12. Any ideas here?A: As for your first question, that's probably an issue of formatting. A lot of times people will just add data into cells when the entire column of cells is formatted to a specific alignment. You can change the alignment of one or more of those cells, but it doesn't change the format of the entire column. If you click the Column header (above the very top cell - it will be labeled with a letter) to select the entire column and then you set the alignment, that alignment shouldn't change. If it does, there could be an issue with your template or even a conditional formatting.
Regarding the second portion of your question, you need to set the default date format in Calc. To do this click Tools | Options and then expand the LibreOffice Calc section. Within this newly expanded section, you will see a listing for Calculate. Click that entry, and then select which default date format you want.Ask Jack: If you have a DIY question, email it to me, and I'll do my best to answer it. (Read guidelines about submitting DIY questions.)