I recently received some help on this excellent forum. The formula worked very well for me. But I am one of those people that want to know how things work, just to thoroughly understand it's function. This is no way meant any negative connotation to how I received the help. But many days passed and I marked my post solved. But after messing with the formula for other situations (it works VERY well). I am just curious what it does.

The formula is:

=IF(ISNUMBER(MATCH(TEXT(A2,"0"),Sheet2!A$2:A$19,0)),TEXT(A2,"0"),"")

What is the function of the "0" in the portion of the formula after (in both cases) (TEXT(A2,"0")

I understand the other sections of the formula. Does the "0" in this particular context mean - looking for content that isnottext?

I very appreciate any help.

## Bookmarks