Dear all,
I have a problem with adding up rows of numbers.
I have "dragged" the mouse across the row of figures, then click the Autosum
icon but the row does not add up correctly. It shows as a format :-
=SUM(B1:AI1).

Is there something I am doing wrong?
Many thanks for any help.
--
Barry Angus
Novice

This e-mail is intended for the recipient(s) only.
All e-mails are scanned for viruses etc prior to sending.

It is possible that the numbers are text.

Format them to General then copy an an empty cell.

Select the numbers.

Edit>Paste Special>Add>OK>Esc.

This step should force the numbers to become numbers.


Gord Dibben MS Excel MVP

On Sun, 08 Jan 2006 17:49:40 GMT, "ntlworld"
<(E-Mail Removed)> wrote:

>Dear all,
>I have a problem with adding up rows of numbers.
>I have "dragged" the mouse across the row of figures, then click the Autosum
>icon but the row does not add up correctly. It shows as a format :-
>=SUM(B1:AI1).
>
>Is there something I am doing wrong?
>Many thanks for any help.

Hi Gord
Many thanks, with your help, I seemed to have solved the problem.

As I had originally just put numbers in the columns/rows, I did not realise
some may have been classed as text!
Again, Thanks
Barry

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> It is possible that the numbers are text.
>
> Format them to General then copy an an empty cell.
>
> Select the numbers.
>
> Edit>Paste Special>Add>OK>Esc.
>
> This step should force the numbers to become numbers.
>
>
> Gord Dibben MS Excel MVP
>
> On Sun, 08 Jan 2006 17:49:40 GMT, "ntlworld"
> <(E-Mail Removed)> wrote:
>
>>Dear all,
>>I have a problem with adding up rows of numbers.
>>I have "dragged" the mouse across the row of figures, then click the
>>Autosum
>>icon but the row does not add up correctly. It shows as a format :-
>>=SUM(B1:AI1).
>>
>>Is there something I am doing wrong?
>>Many thanks for any help.
>

Good to hear you're sorted out.

Gord

On Sun, 08 Jan 2006 20:41:16 GMT, "ntlworld"
<(E-Mail Removed)> wrote:

>Hi Gord
>Many thanks, with your help, I seemed to have solved the problem.
>
>As I had originally just put numbers in the columns/rows, I did not realise
>some may have been classed as text!
>Again, Thanks
>Barry
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:(E-Mail Removed)...
>> It is possible that the numbers are text.
>>
>> Format them to General then copy an an empty cell.
>>
>> Select the numbers.
>>
>> Edit>Paste Special>Add>OK>Esc.
>>
>> This step should force the numbers to become numbers.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Sun, 08 Jan 2006 17:49:40 GMT, "ntlworld"
>> <(E-Mail Removed)> wrote:
>>
>>>Dear all,
>>>I have a problem with adding up rows of numbers.
>>>I have "dragged" the mouse across the row of figures, then click the
>>>Autosum
>>>icon but the row does not add up correctly. It shows as a format :-
>>>=SUM(B1:AI1).
>>>
>>>Is there something I am doing wrong?
>>>Many thanks for any help.
>>
>

Gord Dibben MS Excel MVP