Occasionally when I'm entering values into a Numbers pop up menu, Numbers decides to reformat my text. In this particular case, it is reformatting ratios (6:6) to time (6:06). If I put spaces between the characters (6 : 6), it reformats it to (6m 6s). Numbers has done the same thing in other instances as well. Is there a way to force Numbers to treat all entries in a pop up menu as text and leave them alone?
MacBook Pro Apple Silicon
Numbers will attempt to format entries the same as it does when entering data into a cell. In a cell, though, you can pre-format the cell as text or precede your entry with an apostrophe to force it to be text. You can't do that when creating/editing a popup menu in the format sidebar. Regardless, I find it easiest to create pop up menus in a table versus editing/adding the items in the sidebar.
In a column of a table, list the items you want in the pop up menu then format those cells to be a pop up menu.
Numbers will attempt to format entries the same as it does when entering data into a cell. In a cell, though, you can pre-format the cell as text or precede your entry with an apostrophe to force it to be text. You can't do that when creating/editing a popup menu in the format sidebar. Regardless, I find it easiest to create pop up menus in a table versus editing/adding the items in the sidebar.
In a column of a table, list the items you want in the pop up menu then format those cells to be a pop up menu.
Numbers reformats text in pop up menu to time
