Apple Number Pop-up Option stripping leading zeros

Question

Level 1

8 points

Apple Number Pop-up Option stripping leading zeros

In the Pop-up drop down window I have a list of number 00 through 20. I do need to have the lower numbers to have a leading zero, such as 01, 02, 03 etc… however, when using the Pop-up function the leading zeros are striped away (1, 2, 3 etc…). I certainly could back to make the cells a text but…

Posted on Oct 16, 2022 09:16 AM

Reply

Answer 1

Top-ranking reply

Badunit

Level 7

29,886 points

Oct 16, 2022 03:04 PM in response to smash09

I'm not sure what you ended up doing.

I often use a table to create pop-up menus because it makes them easy to create and kind of easy to change. For the screenshot below I did the following:

Formatted column B as Numeral System with 2 places (like Barry's suggestion)
Populated it with the numbers (entered the first two then dragged down).
Selected all the numbers and formatted them as pop-up menu. This turned them all into the pop up menu you see on the right.
Copy/pasted one of them to C2 (which was originally formatted as Automatic) to try it out and make sure it kept the leading 0. You don't need to do this; you can copy/paste it to the places you need it.

Reply