Excel automatically converts the percentage value in List to number

[srini86]

Hi All,

Please help me on this below issue.

I have list using Data Validation. List has some percentage values.

Excel automatically converts the percentage to number whenever i select the percentage value from List.

[Shareez Saleem]

Even though you have given a set of percentages to drop down, the applied cell format is in General. Convert that to Percentage.

[davsth]

If you have a cell than can contain a number and text how wold excel know what format to apply?

you can have the validation list all formatted as text, then it doesn't matter

or

apply a conditional format so that if the value is 1 or less it is %, but otherwise number the default

[srini86]

Thank you Shareez and Davsth for your information.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.