It works correctly for me, user formatted as you describe I get 1-Jan-72.
Windows XP Pro, OOo 2.2.0. Sorry that I cannot help you.
I wonder how it looks if you however formate the cell DATE and choose
the seventh choice from the top, it shows 31.Dec.1999 and shows the
formatting as D.MMM.YYYY what display do you then get?
31.Dec.1999 is almost what you want, 31-Dec-99.
Joe Conner, Poulsbo, WA USA
Steven Lim wrote:
Hi.
With cell format set to user define - D-MMM-YY, i keyed in 01/01/1972
in cell and the date auto subtracted and appear as 31-Dec-71. Tried
several times and this still happens.
Please assist.
Regards.
Steven.
_________________________________________________________________
Get MSN Messenger emoticons and display pictures here!
http://ilovemessenger.msn.com/?mkt=en-sg
---------------------------------------------------------------------
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]
