On Wednesday 22 June 2005 03:48 pm, Morten Welinder wrote: > In A1, enter 2005-06-21 > In A2, enter =A1+1 > > Dates are just numbers formatted to look like dates. > > Morten
This works on sheet 1 and fails on sheet 2 in cells with formatting identical to sheet 1. On sheet 2 I get I get ###. On sheet 1 the value runs over the next cell which is blank. I can get the value to display properly in sheet 2 by reducing the font size to 4, but it's hard to read :-) _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list