Page 1 of 1

[Solved] Dates Replaced with #s

PostPosted: Wed Dec 19, 2007 7:42 am
by gerowen
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?

Re: Dates Replaced with #s

PostPosted: Wed Dec 19, 2007 9:24 am
by Martin.Flynn
Right click your column header>optimal column width>OK

Re: Dates Replaced with #s

PostPosted: Wed Dec 19, 2007 9:38 am
by gerowen
I=noob, thank you.