Change the pill to discrete, that should stop it becoming a circle and make sure it's a number.
Sorting in tableau can be a pain. It tends to sort by the left. In your name example create a calculated field combinging the last name and first name, put this pill to the left of the rows shelf so it's the first thing - hence the sorting column, and if you don't want the users to see it just right click on the pill and uncheck Show Header.
Hope that works for you, I haven't tested that it will as only got a spare 2 mins to contribute right now.
Thanks, I'll try all that. But is it possible to sort on multiple columns (not at the same time). e.g. I want to sort on Last Name but then I want to sort by Sales Region completely independently.
It's not possible to sort on multiple columns in a straightforward way. If you want to sort by 2 columns I suggest you create a calculated field that concatenates them and sort by that. Tableau doesn't have Excel like sort functionality.