Sum will not display
Thanks, but I think you should re-read Bob's post.
You have created "numbers" that are text by enclosing them in quotes "15"
=B3+D3 will work with text numbers but not with other functions like =SUM or
=AVERAGE
And a Happy New Year to yourself.
Gord
On Sat, 30 Dec 2006 13:08:00 -0800, EOCSUP
wrote:
I was using your first example, and it wanted the second. It worked. Thank
you soo much! Happy New Year to you.
Gord Dibben MS Excel MVP
|