Did not see any attachments and we DISCOURAGE attachments here.
I use 2002.


--
Don Guillett
SalesAid Software

"Maxwell" wrote in message
...
Don, I get the attached results uing both your and HTH's formulas that
rely on LEFT. I'm running Excel 2003. What version are you using?


Seth

On Thu, 16 Jun 2005 11:13:53 -0500, "Don Guillett"
wrote:

=SUMPRODUCT((LEFT(E2:E5)="2")*1)
222
0235
00025
00250


number
text
formatted with leading 0's
ans is 1 for the 222