Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Billy
Billy asked in Computers & InternetProgramming & Design · 1 decade ago

How do I make an Excel Cell allow Specific letters?

I have an Excel Sheet with a column that I want only a specific letter to be entered. ie Cell A1 can only have ONE of the following P,L,T,I,or O and NOTING else. Can this be done and if so how?

2 Answers

Relevance
  • voyager
    Lv 6
    1 decade ago
    Favorite Answer

    Try Data Validation

    - Select A1 & click "Data Validation" on the Data tab

    - Click "List" in the "Allow" dropdown list

    - In the Source box, type P,L,T,I,O. Click OK.

  • Anonymous
    1 decade ago

    Excel can do alot of auto formatting with number styles select column you want to modify  > Format > Cells, see your options. I don't believe there is any way to do specific set letters.

Still have questions? Get your answers by asking now.