View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Ignoring comma when creating validation lists

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

Tim

--
Tim Williams
Palo Alto, CA


"Christiano Borchardt" wrote in message
...
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