Re: Copy & Paste in Calc changes date - nasty

[Jim Watson <jim@amarooas.com.au>]

On Tue, Nov 16, 2004 at 03:00:12PM +0000, Clive Menzies wrote:
> 
> It is quite a feature and I can see how it could be useful.  However, I
> exchange spreadsheets with windows users and I suspect that the problem
> arises because Excel uses a different base date.  Some of my

Clive,

if this is important for you, then you could store the dates in three
columns as day-month-year and use the date formula to produce the dates.
this is tiring but portable. for example

A1=2001
A2=12
A3=5
A4=DATE(A1;A2;A3)

thanks

jim