Ignoring comma when creating validation lists

Hi,

I'm working in an application that generates an excel file with a data
validation list. The problem its because my values im putting in that list
also contains comma characters, but i dont want to split up this value.
Someone knows if there is a special character i can put at the string to
appears as a comma when using the dropdown?

Thanks
Christiano

Be more specific; include a snippet of your code if possible. It may be that
you simply need to enclose the portion of the string containing the commas
within quote marks.

"Christiano Borchardt" wrote:

> Hi,
>
> I'm working in an application that generates an excel file with a data
> validation list. The problem its because my values im putting in that list
> also contains comma characters, but i dont want to split up this value.
> Someone knows if there is a special character i can put at the string to
> appears as a comma when using the dropdown?
>
> Thanks
> Christiano

Create a named range (could be in a hidden sheet)

Tim

--
Tim Williams
Palo Alto, CA


"Christiano Borchardt" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm working in an application that generates an excel file with a data
> validation list. The problem its because my values im putting in that list
> also contains comma characters, but i dont want to split up this value.
> Someone knows if there is a special character i can put at the string to
> appears as a comma when using the dropdown?
>
> Thanks
> Christiano

Put your list in a range (on a hidden worksheet???) and name that range. Then
use that name in your Data|validation list box.



Christiano Borchardt wrote:
>
> Hi,
>
> I'm working in an application that generates an excel file with a data
> validation list. The problem its because my values im putting in that list
> also contains comma characters, but i dont want to split up this value.
> Someone knows if there is a special character i can put at the string to
> appears as a comma when using the dropdown?
>
> Thanks
> Christiano

--

Dave Peterson