Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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 Apple recommended

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.

Posted on Jul 13, 2022 8:50 AM

2 replies

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 ID.