Steven Lim-3 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.
>
>
The only thing that occurs to me is your "Date" (start date) setting. Look
at Tools >Options >Calc >Calculate. On the top right of the panel, under
the heading "Date", you should have 30/12/1899(default) selected.
AFAIK, the setting only has the effect you mention when altered after a date
is entered. IOW, if I enter 1/172 when the second option (StarCalc 1.0) is
selected and subsequently change the setting back to the default, the date
changes to 31/12/71. Did your spreadsheet by any chance begin life as a
StarCalc document?
BTW, the format D MMM YY is standard in my version and the date enters and
displays correctly.
--
View this message in context:
http://www.nabble.com/Calc---Date-auto-subtract%21-tf3544752.html#a9896609
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
