Forum Discussion
Solved
Drop down list changes number to store number as text when select
Hi, Using a Drop Down List to select a number formatted as a number from another table. However, when selected it converts the number to text. I have conditionally formatted the cells using th...
The reference for your data validation list was the header of a table. These header values are stored as text, hence why the numbers were stored as text. Please refer to changes in the attached workbook.
Hello HConlin_2012,
Make sure that the cell that contains the drop-down is formatted as Number or General.
PReagan Cells with drop down list are formatted for numbers but as soon as select from the list the value (that is a number from a cell also formatted as a number) changes to stored as text. Yes data validation list is all numbers.
If possible, could you share a sample version of your workbook? (please remove any sensitive data of course)
PReagan Sure
