Formatting does not make any difference once the entry is made. What do you
get when you try:

=ISTEXT(<any cell in your range)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"SLP" wrote in message
...
Hello. I am trying to do an =sum for 205 rows. The result is 0. I
checked
Tools | Otpions -- Automatic is set. The cells leading into the =sum are
formatted as numbers. (Also tried it with General). The cells that lead
into
those cells are not text. Any ideas on what is wrong? Thanks.