You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello.
Can you please tell me if there is any way to get around the absence of Excel's TEXT function in Numbers?
My intention is to transform a date into text, for example, dd-mmm-yyyy into just mmm-yyyy.
My thanks in advance.
Manuel
Are you looking to change the underlying value of the cell? or just the way it's presented?
Normally, if you want a date shown as mmm-yy you can do that through cell formatting, where you can define which elements of a datetime cell you want to show (and is, if I remember correctly), essentially what Excel's TEXT() function does - takes a value and a formatting string to define how to show the value.
Failing that, in the absence of the TEXT() function, you can construct it yourself using text functions like:
=LEFT(MONTHNAME(MONTH(A2)),3)&"-"&YEAR(A2)
(Assuming A2 has a date value)
Hello Camelot.
I am trying to work with Numbers instead of Excel and I really appreciated your help.
It worked perfectly.
Many thanks.
How to transform a date into a text
