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
I have tried various things in
Format cells > Number > custom
with no luck. Is there a simple solution to this?
thanks,
Bogzla