I have a number of rows of data, all of which has a date in one cell in format of dd/m/yy. In a subsequent cell i am running a mid function to determine the month number. However, the format of the date seems to be a number i.e. 40909 rather than 01/1/12, and therefore my mid function is pulling out 9 rather than 1. I've tried everything to reformat the date cell but it makes no difference