I want to add magnetic headings. I need to enter the degrees as 3 figures. ie
045
I have found that I can do that when I add the degree sybmol to the figure.
But when I try to use the sum command, it wont add because the field
contains the symbol.

=SUMPRODUCT(--SUBSTITUTE(A1:A3,"x",""))

replace the x with your degree symbol

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bablefish" wrote in message
...
I want to add magnetic headings. I need to enter the degrees as 3 figures.
ie
045
I have found that I can do that when I add the degree sybmol to the
figure.
But when I try to use the sum command, it wont add because the field
contains the symbol.

Use custom formatting:

000°

Use this for both the values and the sums. The degree symbol is in the
formatting, not the cell.
--
Gary''s Student - gsnu200734


"Bablefish" wrote:

I want to add magnetic headings. I need to enter the degrees as 3 figures. ie
045
I have found that I can do that when I add the degree sybmol to the figure.
But when I try to use the sum command, it wont add because the field
contains the symbol.