da_jane:
Excel programming goes beyond the general bounds of calibre support, but in the interest of happy calibre campers, here's how you can convert a calibre timestamp to an Excel date:
Code:
=DATE(MID(A1,1,4),MID(A1,6,2),MID(A1,9,2))
The formula will convert the calibre date in cell A1 to an Excel date, which you can then format as you wish using Excel's date formatting.
G