I have a CSV file that contains record information and some dates. From this I want to calculate the Month in which the ticket was created. The cell I am trying to convert or use in the formula resides in column I and looks like this 1/6/2015 3:33:28 AM. I first tried using the formula =Month(I2) to get the month. But when I copy that formula to all of the rows, 43713 of them, they all returned the same result, in this case Jan. I have data in every month should see all of the months up to and including July. I have spot checked several formula entries and they are using the correct cell for the calculation, in other words it isn't a copy error. So then I thought I would try just pulling the first entry of the date record, the month number, by using =Left(i2,1). But this time I got the number 4, which isn't what I would have expected at all. Any other suggestions I can try?