I have created a spreadsheet in LibreOffice with dates formatted. This cannot be read by Excel. Can anyone advise why and the best way to sort this

Suesouthwood · October 13, 2020, 3:06pm

I have inputted dates as DD/MM/YYYY on my spreadsheet. When I send this to a colleague using Excel spreadsheet these appear as #####

anon73440385 · October 13, 2020, 3:27pm

Related to your “Answer”: Please provide a sample file. Use the paper clip symbol to upload the file while **edit**ing your question.

And it you are at it, please provide information about.

Your operating system
Your LibreOffice version (+ resource whe you got it from)
File format you save the document you sent to your colleague (.ods or something else)

gabix · October 14, 2020, 4:48am

Make the title short.

anon73440385 · October 13, 2020, 3:17pm

Hello,

ask your colleague to increase column width - ### is an indicator that the column is not wide enough to show full (number type) content.

image description

Hope that helps.

Suesouthwood · October 13, 2020, 3:21pm

Thanks we have tried that but it doesn’t work

anon73440385 · October 13, 2020, 3:24pm

Please do not use Add Answer if you actually don’t answer a question but commenting an answer or responding to another user’s comment. Please use add a comment for that purpose. Thanks in advance …

erAck · October 13, 2020, 3:25pm

If the dates are smaller than 1900-01-01 Excel doesn’t handle such.