Hi I need to find out if a number cell in a cloumn contains "," ...
i need to fire msgbox when i come across cell containg value 31,205
...string functions ... are not working .

Can you test for the number being 999 and the cell formatting's
NumberFormat containing ","?

Gregg Roberts