Hi Gord

I tried to use the range but doesn't work in my case.
I am getting the list of values from the database and I am storing that in a
comma delimited string. I tried if can copy that string into range but it
doesn't work. If you or anyone has suggestions then please help me.

Thanks
--
bprajap


"bhavna" wrote:

Thanks Gord for the reply, I will try this. It looks like a good solutions.
--
bprajap


"Gord Dibben" wrote:

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