You need to change the format of the cell by entering the Format Cell dialog and selecting the number tab. From there, you select date and choose the appropriate sub format.
By the way, '01/04 is not a date - and cannot be processed as a date by OOo Calc. It is a string. Dave -- My OpenOffice Calc Website http://www.openofficetips.com On 4/13/05, Yong Bong Fong <[EMAIL PROTECTED]> wrote: > Dear friends, > > I wish to enter a date format in the cells as "01/04-", but each > time I enter 01/04- it automatically change it to 01/04/05. > The one way I can stop it from changing is by typing in '01/04- , that > way it will keep that date as 01/04-. > > I know that we can solve this problem either by adding a ' before the > date or by formatting the cells. > But my client (I am providing support for my company's migration) > doesn't like it. She said last time when she entered 01/04- it stays aas > what she typed by default. She didn't need to do any formatting or add a > ' in front. I am not sure if what she says is true....if anyone knows, > please guide me. > > Thanks for helping, > > -- > Yong Bong Fong (Ah Fong) > Rookie System Engineer > MIS Department > Shin Yang Group of Companies > Email: [EMAIL PROTECTED] > Tel: (60)085-656699 Ext 375 > Mobile: 019-4870346 > "Bekerja Rajin Untuk Kemajuan Negara Kita" > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
