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.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
