Enter your list in a range of cells.

When selecting source for list use that range rather than a comma-delimited
list.


Gord Dibben MS Excel MVP

On Fri, 5 Sep 2008 13:37:08 -0700, bhavna
wrote:

Sorry about not being clear.
What I mean that I want to have data validation for a column with a list.
And as you know that list items needs to seperated with comma. My question is
that how can use a list item with comma. e.g. #,0, #.0 etc. In my case I want
my list to look like
#,0
#.0

Thanks