[Solved] Dates Replaced with #s

Discuss the spreadsheet application
Post Reply
gerowen
Posts: 2
Joined: Wed Dec 19, 2007 7:38 am

[Solved] Dates Replaced with #s

Post 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?
Last edited by Hagar Delest on Tue Jun 10, 2008 3:57 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
Martin.Flynn
Volunteer
Posts: 96
Joined: Wed Nov 28, 2007 7:52 pm
Location: Moray

Re: Dates Replaced with #s

Post by Martin.Flynn »

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
gerowen
Posts: 2
Joined: Wed Dec 19, 2007 7:38 am

Re: Dates Replaced with #s

Post by gerowen »

I=noob, thank you.
Post Reply