[Solved] Dates Replaced with #s

Discuss the spreadsheet application

[Solved] Dates Replaced with #s

Postby gerowen » Wed Dec 19, 2007 7:42 am

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

Re: Dates Replaced with #s

Postby Martin.Flynn » Wed Dec 19, 2007 9:24 am

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
Martin.Flynn
Volunteer
 
Posts: 96
Joined: Wed Nov 28, 2007 7:52 pm
Location: Moray

Re: Dates Replaced with #s

Postby gerowen » Wed Dec 19, 2007 9:38 am

I=noob, thank you.
gerowen
 
Posts: 2
Joined: Wed Dec 19, 2007 7:38 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 11 guests