John E. Perry pecked at the keyboard and wrote:
Ken Schneider wrote:
I help keep track of members in a club I belong to and use a spreadsheet to do so. For the Birthday field we only use month/day (no year) for privacy reasons. The format for the cells is MMM DD which properly shows as Jan 31 displayed in the cell. But the cell contents default to 01/31/2008 showing a year which is _not_ wanted when printing a club roster.
Ken,
Right-click on the column header, then click Format Cells -> Numbers -> Date.
You'll find a couple of dozen options, among which will be at least two like what you want. This is in OO 2.4 here, but it's been there a long time -- at least since whatever was in suse 9.1, when I started using OO.
John Perry
This is what I have set but when you look at the actual contents of the cell the year shows and the year also prints in mail merge labels. This is with 2.3 in 10.3 and 3.0 in 11.1b3. -- Ken Schneider SuSe since Version 5.2, June 1998 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org