try using
range("A1").numberfornat like "*,*"

"Nick Hodge" wrote in message
...
I'd wonder before starting this whether the ',' isn't actually in the
format and not the value of the cell. If it's in the actual cell data
then it will be a string search

Excel may display 31,205, but it will actually be storing 31025 so looking
for the ',' will not work. Check this out by highlighting the cell and
looking at the value stored in the formula bar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk


"vbastarter" wrote in message
...
Hi I need to find out if a number cell in a cloumn contains "," and the
fire
a msgbox
i need to fire msgbox when i come across cell containg value 31,205

Usually, i would use instr or other string functions but being a number,
thosse strigs are not working .

Any help appreciated.