Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
marcia2026 marcia2026 is offline
external usenet poster
 
Posts: 48
Default Data Validation

I have a spreadsheet that requires certain abreviations to be placed in one
column. I want to be able to show the user what choices that they have from
a drop-down list (i.e. Alabama - AL) but only put the abreviation in the
actual cell. How do I accomplish this?