Validate cells to only accept

[Haydn_17]

I have to validate a cell to only accept the letter a, d ,f ,g h,

I know this is probaly very simple but i havent touched excel since last november and have completely forgotton the most simple of things!

Thanks

[sweep]

Data > Validation > List > Source > a, d ,f ,g h

[Haydn_17]

Data > Validation > List > Source > a, d ,f ,g h

Im using 03 and i cant find list

[sweep]

is it not in the dropdown "allow" menu in the validation dialog box?

[Haydn_17]

is it not in the dropdown "allow" menu in the validation dialog box?

Oh i see ive got it now, thanks mate

[Aggelos]

This almost drove me crazy! I tried it several times and it wouldn't work. Entering a,b,c,d in the source box resulted in only the whole of this sequence being accepted ("a,b,c,d"). Separate letters, i.e. a or b or c or d would not be acceptable!

I then tried using ";" instead of commas (",") and it worked perfectly. Why is that so?

[Fotis1991]

Άγγελε(Aggelos). Welcome to the forum.

This is because in most Countries of the world, they use comma, as we in Greece, use semi-colons.