I want to display text only in a cell

I want to insert text like "127/70" or "80/24" as text only, but Numbers automatically treats that as a division formula and gives me a result. I can't find out how to convert the cells to display the text I enter and not execute a formula. Web and documentation searches have not helped. Any recommendations?

Mac Pro

Posted on Jul 13, 2022 8:41 AM

Reply
Question marked as Top-ranking reply

Posted on Jul 13, 2022 8:50 AM

Two solutions:

  1. format the cell as TEXT before entering the text
  2. enter the text after an apostrophe:' like this: '127/70 or '80/24 (Numbers will consider this as text)


Paul.

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

I want to display text only in a cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.