Slicers with Numbers and Text

I am building an Excel dashboard of promotional sales data for several retail locations. As the dashboard's charts are constructed from pivot tables, I am trying to use slicers to list the different promotions. The promotions have both a number and a text string name, and reference to either of these is interchangeable, so both need to be reflected in my dashboard. Ideally, a slicer tab would look like "1. Promotion String A", "2. Promotion String B", etc., but my attempt at this read the entire field as text and sorted promotions 10-19 in between 1 and 2. I have not found a solution for text string slicers that sort with leading numbers. Is this possible? I could have a key column to the side listing each promotion name's number and leave the slicers as the promotion numbers, but I was hoping to simplify the reference to have both name and number on the slicer.

Any help would be appreciated. Thanks!

Can you post a sample of what you have at the moment please.

I've built a small example of what I'm discussing but without the dashboard piece. I can build the slicers and connect them to the pivot charts but can't get my slicers to sort efficiently. As these are being presented, some people will be looking for "Promotion #7", others for whatever promotion 7 offers. I suppose I can make a large legend on the dashboard but was hoping to simply incorporate that into my slicers...

See if a Custom List will help you;

https://www.myonlinetraininghub.com/...l-date-slicers

May not be practical but will work.

Kersplash, thanks for your idea - I did consider using a custom list but did see that it had to be created/imported on each computer viewing the file, which will be multiple in my case. If I was a VBA whiz, I'm sure I could set this to happen quite easily each time, but that unfortunately is not my specialty yet.

Andy, your solution is simple but genius and works great! I never thought of leading zeroes - thanks so much!