Forum Discussion
Solved
Combobox return blank for 1st option
Hi, I'm creating a non VBA combobox with the 1st option being "Select" as I need an option to have a null value. I'm referencing the combobox in another formula so can't have "Select" return 1. is t...
- HI,
I used =if(b2=”Select”,c1=”Ascending”,c1=”Descending”) and then added a helper row below to filter out the 1 to use in my next formula. Thanks for your help.
so what about 0? can it return 0?
using custom number formatting you can get cell A1 to SHOW "Select" but have a VALUE of 0
Custom Number Format => 0 ; -0 ; "Select"; @
Then the drop down (at least the one I tested using Data Validation) still showed "Select" but if selected it returns a VALUE of 0
and then you can have that cell use custom number format and not show the 0
Custom Number Format => 0 ; -0 ; ; @
using custom number formatting you can get cell A1 to SHOW "Select" but have a VALUE of 0
Custom Number Format => 0 ; -0 ; "Select"; @
Then the drop down (at least the one I tested using Data Validation) still showed "Select" but if selected it returns a VALUE of 0
and then you can have that cell use custom number format and not show the 0
Custom Number Format => 0 ; -0 ; ; @
