Kyle Bowles wrote:
<snip>. I just began using open office since I came to campus and am
finding one feature extremely annoying. I personally like to write my
dates yyyy.mm.dd however, as you may know Open Office Calc is VERY
picky about them being one way and ONLY one way. <snip>
Sincerely,
Kyle Bowles
What OpenOffice needs is a method for the user to change the default
date format. You could contribute to the project by filing an issue
requesting a feature enhancement. First, you must register here:
http://www.openoffice.org/servlets/Join
In the meantime, there is a simple way to achieve what you want.
First, you need to create a Style. Use F11, right-click on "Default"
and select "New". On the first tab, give your style a recognisable name
such as "_Date". On the Numbers tab, select the format you want.
Then, associate the style with a keyboard combination (I use Ctrl+D)
with Tools >Customise : Keyboard.
I usually use the same column/s for dates in spreadsheet, so I
pre-format those columns by applying my date cell style to them. Click
on the column header to select the column. Then Ctrl+D or F11 >
double-click on the style name or use the "paint" icon. (I don't even
do that because I have templates pre-set and macros which configure a
spreadsheet or enter / reformat data.)
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
