[Solved] Dates Replaced with #s
[Solved] Dates Replaced with #s
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?
Last edited by Hagar Delest on Tue Jun 10, 2008 3:57 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
Reason: tagged the thread as Solved.
-
- Volunteer
- Posts: 96
- Joined: Wed Nov 28, 2007 7:52 pm
- Location: Moray
Re: Dates Replaced with #s
Right click your column header>optimal column width>OK
Rip Van Apache Open Office 4.1.3 / Libre office 5.3.5.2 on Ms Windows 10