Forum Discussion
Solved
Highlighting Content
Hello, not sure how to word my request. But here we go What I am trying to do: I have a pivot table open. With row values that correspond to the month it is needed. Then in column M I have what our ...
B1:J1 contains abbreviated months, while M2:M1068 contains the full month names.
Enter =TEXT(L2,"mmm") in M2, then fill down.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
B1:J1 contains abbreviated months, while M2:M1068 contains the full month names.
Enter =TEXT(L2,"mmm") in M2, then fill down.