[Solved] Date Formatting Errors

Discuss the spreadsheet application

[Solved] Date Formatting Errors

Postby axemangraphics » Fri Dec 20, 2019 12:10 am

I have been transcribing some historical documents (1850s-1920s).
Currently, I have the date as DD/MM/YYYY, however I would like to swap these out for the "Friday, 31 December, 1999" option.
When I do this, approx half of the fields become "####" even though they are formatted exactly the same. I have keyed in "09/09/1856" for example, and at first thought it was a location issue (Australia Vs US date formatting), but then the following dates went screwy too... 14/08/1859, 02/10/1859, 09/10/1859, etc

SOME dates work, some do not. Any ideas?
all are keyed exactly the same (all by me!)

starting to drive me a bit nuts... :knock: :knock: :ucrazy: :ucrazy: :crazy: :crazy:
Last edited by axemangraphics on Fri Dec 20, 2019 1:58 am, edited 2 times in total.
Open Office 4.1.7
MacOS 10.15.2 - Catalina
axemangraphics
 
Posts: 2
Joined: Fri Dec 20, 2019 12:00 am

Re: Date Formatting Errors

Postby RusselB » Fri Dec 20, 2019 12:23 am

Welcome to the Forums.
You can stop going nuts. The #### in the cell is simply Calc's way of telling you that the column isn't wide enough for the information to be displayed as formatted.
Right click on the column letter, then select Optimal Column Width, then click OK. I recommend not changing the two entries that are there.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6119
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Date Formatting Errors

Postby axemangraphics » Fri Dec 20, 2019 1:57 am

what a superstar!! Bah, it shows how long its been since I have worked in Spreadsheets...
thank you!
Open Office 4.1.7
MacOS 10.15.2 - Catalina
axemangraphics
 
Posts: 2
Joined: Fri Dec 20, 2019 12:00 am


Return to Calc

Who is online

Users browsing this forum: jrkrideau and 26 guests