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.

Apple Numbers: is there a way to insert a slash without forcing a formula?

The question pretty much details itself.

Sometimes, when inserting a value into any given cell, I want a slash symbol to stay a slash.

Example: 30/20. I need the slash to remain as it is, but when I leave the cell, it converts it to 1 1/2.

Assume there is an override, even if just for individual cells, but I don't know it.

Thanks

Mac Studio, macOS 14.5

Posted on Sep 21, 2024 11:13 AM

Reply
2 replies

Sep 21, 2024 11:30 AM in response to Rhythm Earthsong

If you don't need a numeric value in the cell then you can select the cell and set the Data Format to Text (you do that via Format > Cell pane and choosing 'Text' from the Data Format dropdown) and then enter what you want.


Or if you don't want to set the format first you can just type an ' (an apostrophe) followed by what you want.


Typing '30/20 will result in 30/20.


SG


Apple Numbers: is there a way to insert a slash without forcing a formula?

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