• 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!

Excel date changed in OpenOffice

5.00 star(s)

Kipper

Nervous Newbie
Joined
Apr 28, 2011
Messages
18
Likes received
0
Thanks received
0
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?:confused:

cheers
 
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?
 
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.
 

Advertisers

Back
Top