Hello,

Im having trouble using MAX in a mixed cell.

My data in column B for example is:

201301 January
201302 February
etc

Using =Max(B:B) however returns a 0 value.

Can anyone help?

Many thanks