I have a spreadsheet where most of the columns are in number format with
2 after the decimal point. Without thinking I put the dates in the first column in the format 05/10/13.The numbers in that column came out as 5-figures-decimalpoint-00. Eg
22/06/13 came out as 41447.00.For the life of me I can't work out how it reached that answer, given the input.
Any ideas anyone?
Hugh