Hi all, having a head scratcher as to how I can set up cells in excel to only allow certain values to be entered... basically what I want is to only allow either a '1' or a '0' to be entered into certain cells (preferably without going into vba coding, but I can use it if necessary).
I have tried various things in
Format cells > Number > custom
with no luck. Is there a simple solution to this?

thanks,
Bogzla

Howdy.

Will Data Validation work? Go to Data > Validation, and in the resulting dialog window, on the Settings tab, in the dropdown at the top choose "List".

Then box below, enter this:

1,2

Uncheck the box that says "in-cell dropdown".

Click OK.

Perfect, Thanks for that, I knew there had to be a straightforward way of doing it :D