no nbrs will all ways be text. the text is entered into a cell on another
sheet then pasted back to the target cell it is shrunk to fit.
Horse drawn carriage Fire truck etc. Can not expect to have any resemblance
to nbrs.
Better desc I hope.
Thanks

"Bernie Deitrick" wrote:

Curt,

It depends on what your target values are. Are they strings that look like
numbers? Some examples of what you expect would help...

Bernie


"Curt" wrote in message
...
Thanks
One more question. The target cell should all ways be text. Is there any
other change I should use?
Sure appreciate the responce

"Bernie Deitrick" wrote:

Curt,

Your comparison

Target.Value <= 0

will get you in trouble, if target.value is actually text. Try:

If Target.Column = 12 And CDbl(Target.Value) <= 0 And
IsText(Target.Value) Then _
Call Announcer(Target)


HTH,
Bernie
MS Excel MVP


"Curt" wrote in message
...
= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value)
Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks