Pop-up Menu Auto Formatting Dates

I have a popup menu that has "January" as one of the items, but it automatically formats it to a date instead of keeping it as it is. For example, if I type "JAN" to name the item in the popup menu list, it automatically converts it to "January" and the actual value is "1/1/2023" (note the "Actual Value" bar at the bottom of the screenshot).


How do I prevent the popup from automatically converting it to a date and just keeping it how I typed it (in this case "JAN")?

Posted on Jun 5, 2023 07:04 PM

Reply
Question marked as Top-ranking reply

Posted on Jun 5, 2023 07:25 PM

This is a quirk of Numbers. In its attempt to be smart it is often "***".


The way I make pop up menus is to list the items in a table, select that range of cells, and format as pop-up menu. You can format each item to be what you want it to be (before converting to pop up menu) and the pop up will honor that format. So, for this problem you are running into:

  1. Format a column of cells as text
  2. Type in your words (Jan, Feb, Mar, and so on)
  3. Select all those cells and format as pop up menu. Include a blank cell in the selection if you want it to "start with blank"
  4. Copy/Paste one of them to wherever you need it. Use the blank one if the pop up starts with blank.



[Edited by Moderator]

3 replies
Question marked as Top-ranking reply

Jun 5, 2023 07:25 PM in response to PuddleOfFat

This is a quirk of Numbers. In its attempt to be smart it is often "***".


The way I make pop up menus is to list the items in a table, select that range of cells, and format as pop-up menu. You can format each item to be what you want it to be (before converting to pop up menu) and the pop up will honor that format. So, for this problem you are running into:

  1. Format a column of cells as text
  2. Type in your words (Jan, Feb, Mar, and so on)
  3. Select all those cells and format as pop up menu. Include a blank cell in the selection if you want it to "start with blank"
  4. Copy/Paste one of them to wherever you need it. Use the blank one if the pop up starts with blank.



[Edited by Moderator]

Jun 5, 2023 07:33 PM in response to PuddleOfFat

This is the easy way to make pop up menus anyway so it serves that purpose even if you aren't trying to get around this quirk.


Oh, and the word that got starred out in my post was the common antonym to "smart" that you can say anywhere, including in church (at least when talking about something inanimate), except I guess not here. I find that, itself, to be "the opposite of smart".

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.

Pop-up Menu Auto Formatting Dates

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