Excel date changed in OpenOffice

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Kipper replied

6 May 2011, 19:28
Many thanks for that - solved by formatting.
Leave a comment:
Sysman replied

6 May 2011, 15:37
Right click on the cell (or column header) and pick "Format cells..." from the drop down menu.

Click on Date, then in the middle column the format you want.

40422 comes out as 01 September 2010.
Leave a comment:
MrMark replied

6 May 2011, 14:11
Is there no way you can change the format of that field/column? That figure looks suspiciously like the underlying value saved by the spreadsheet, and all you need to do is set the format that you require?
Leave a comment:
Kipper started a topic Excel date changed in OpenOffice

6 May 2011, 11:06
Excel date changed in OpenOffice

I have been moving all my business files from Win XP to Ubuntu and this included my accounts in MS Excel.

I have opened the accounts xlsx file in open office but am baffled by the listed date format that it shows.

Instead of the 01/01/11 format I used to log accounted items it now shows a five digit number EG: 40422 which I can only assume is a computer generated date marker of some sort.

I can not find a way of changing this back through the spreadsheet software. As it is the date code isn't usable for me. Does anyone know anything about this please?

cheers
Tags: None