Cell number formatting issue in Excel

I DO NOT NEED THIS POST ANSWERED. I CANNOT FIGURE OUT HOW TO DELETE A POST.



I received a Google spreadsheet which is View Only. One of the columns is for age range of participants at a rugby clinic. There are 316 entries and 13 of them have an age range displayed as 14-19. All the other cells in the age range column are five digit numbers. All the age range cells have their formatting set to automatic.

I asked the person who sent my the google spreadsheet and they were no help. I want to send emails, but i wan to ensure they only go to high school aged people.

I'm going to assume I'm out of luck for associating the five digit numbers to a number like 14-19.

Example attached.

Thanks for your time and attention.

You cannot delete a post. In the future if you no longer need help, just mark it SOLVED. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

This thread has been closed so it will not accept further replies.