medium10 pts · first answer countsexceldatestext-functions

Month labels sort in the wrong order

A helper column uses =TEXT(A2,"mmm-yy") to label months, and a pivot on it lists Apr-26, Aug-26, Dec-26, Feb-26 and so on. Why?

A.TEXT always converts dates to the US formatB.Pivot tables cannot sort by any month name at allC.TEXT returns text, which sorts A to Z, not by dateD.The format code "mmm" means minutes, not months

Discussion 0

Join free to post in the discussion.

Month labels sort in the wrong order

Discussion 0

Related questions