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.
📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Seems there is still no TEXT function in Numbers in iOS.
There are of course the two excellent work-arounds suggested by Barry (March 2020: format hidden cell, and concatenation).
I have also found that I can format the cell in Microsoft Excel, then copy that cell into Numbers which will display the formatting chosen in Excel - not sure if that works for all formatting but it seems to do the trick for dates :)
iPad Pro
In Numbers one typically formats how a number displays by selecting it and going to the Data Format dropdown menu in the Cell tab of the inspector pane on the right. A Custom Format can be created there if needed.
Unlike the TEXT function in Excel the number remains a number instead of being converted to text. That means it can still be used for calculations.
SG
Sorry, I should have specified: this work-around is for iPad and iPhone users - iOS does not (yet) have that kind of flexibility.
Question: Did I post in the wrong section? (e.g. Mac section instead of iPad/iPhone section)
The Numbers for Mac and iWork for iOS/iPadOS used to be separate. But now this is the forum for questions on Numbers for both platforms.
It is good to know Numbers on the iPad respects formats set in Excel.
I haven't tried it for a while but I believe it will also respect a Custom Format set on the Mac.
SG
Work-around for missing Text function in iOS Numbers
