On Sunday April 08 2007 6:25 pm, TerryJ wrote: > 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.
Copy to Steven. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
