How to remove the "0" that appear in front of my (text) after converting the (date).

TDobson

I am using this formula to convert the numerical date to a text Month only. It works, however there is now a zero in front of the text. Does anybody have a suggestion for a solution.

=IF(MONTH(Created@row) = 1, "January") + IF(MONTH(Created@row) = 2, "February") + IF(MONTH(Created@row) = 3, "March") + IF(MONTH(Created@row) = 4, "April") + IF(MONTH(Created@row) = 5, "May") + IF(MONTH(Created@row) = 6, "June") + IF(MONTH(Created@row) = 7, "July") + IF(MONTH(Created@row) = 8, "August") + IF(MONTH(Created@row) = 9, "September") + IF(MONTH(Created@row) = 10, "October") + IF(MONTH(Created@row) = 11, "November") + IF(MONTH(Created@row) = 12, "December")

Paul Newcome

Nested basically takes the 2nd IF and places it inside of the third portion of the 1st IF. The 3rd IF gets nested in the third portion of the 2nd IF. The 4th IF gets nested in the third portion of the 3rd IF. The 5th IF gets nested in the third portion of the 4th IF. So on and so forth. There are A TON of examples (mostly dealing with RYG type columns for "health") here in the community.

=IF(1st argument, true_value, IF(2nd argument, true_value, IF(3rd argument, true_value)))

Paul Newcome

I don't see where the zero would be coming from. Is that the full formula, or is that a portion of a larger formula?

TDobson

That would be the full formula. So the formula is not generating the problem. Perhaps it is the way the sheet is set up.

Paul Newcome

Are you able to provide some screenshots? If that is the full formula, then I have no idea where the zero is coming from just by looking at that bit.

TDobson

Here you go. The Month row is where the 0s are. I have been able to successfully edit them out in the pivot table so that they appear without the 0s. But knowing why would be good.

Paul Newcome

Try adjusting the formula so that it is ""nested" instead of "added". I get the feeling that if the month ends up being January then there won't be a zero in front of it.

TDobson

Good morning Paul,

Thank you for your help, forgive my ignorance, but could you provide an example of what, "nested vs added" looks like. I understand that my formula is added.

Paul Newcome

Nested basically takes the 2nd IF and places it inside of the third portion of the 1st IF. The 3rd IF gets nested in the third portion of the 2nd IF. The 4th IF gets nested in the third portion of the 3rd IF. The 5th IF gets nested in the third portion of the 4th IF. So on and so forth. There are A TON of examples (mostly dealing with RYG type columns for "health") here in the community.

=IF(1st argument, true_value, IF(2nd argument, true_value, IF(3rd argument, true_value)))