Apache OpenOffice Community Forum

I use a spreadsheet as my checkbook, however even after formatting cells to use the date format "17 Dec. 2007" it insists on replacing my date with "####". If I try manually typing it in the way I want it, then formatting it that way, it still does it, ideas?

Right click your column header>optimal column width>OK

I=noob, thank you.