Dan Lewis wrote:
Bottom Post
On Tuesday 30 August 2005 10:11 am, David Chapman wrote:
Dennis,
I also have 1.1.4 (on Solaris) but I am not seeing the prob you
report (assuming I understand you correctly) Perhaps someone else can
comment?
Feel free to send me example sheet off the list.
Dave
On 8/30/05, Dennis J. Tuchler <[EMAIL PROTECTED]> wrote:
OpenOffice.org (Linux) 1.1.4: In Calc, when I change the date
format to MM/DD, and enter a date (e.g. 8-30), the cell shows it in
MM/DD/YY format. I look back at the cell format setup, and see the
format is supposed to be MM/DD for that cell. How can I fix this?
Thanks
Best regards,
Dennis J. Tuchler
I have OOo 1.1.4 (Linux). I changed the date format to MM/DD in a
new spreadsheet and entered 8-30 in cell A1. 08/30 was shown in the
cell. So, it works for me.
If you highlight the cell containing 8-30, what appears in the Input
line? (Box to the right of the "=" icon and directly above columns C
on.) If there is an apostrophe ('8-30) before the 8-30, Calc will
treat this entry as text.
The input box shows the date in MM/DD/YY format. Oddly, the Cell Format
Numbers menu shows the "Date" format as MM/DD. So something is weird.
In the cells for which this format is selected, when I enter 8-22, it
comes out 08/22/2005. It is as if the spreadsheet developed its own
will and insists on that format :].
--
Best regards,
Dennis J. Tuchler
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
