Re:Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VK2KCE - 16 Oct 2007 01:25 GMT

Hello all, I wonder if anyone can help me? Please?

I have a spreadsheet and its a month by month expense sheet for a local
club.

Problem is that when I try to add all the months total expenses, i.e.
January, February etc, the total of each month at the bottom of the sheet is
0.00.

I have checked all the formulae and its correct, it relates to each months
totals.

What is wrong?

Thank you
John

Reply to this Message

Gord Dibben - 16 Oct 2007 02:07 GMT

Typically this is caused by the numbers being text and not real numbers.

Format all to General then copy an empty unused cell.

Select to range of numbers and Edit>Paste Special(in place)>Add>Esc.

Gord Dibben MS Excel MVP

>Hello all, I wonder if anyone can help me? Please?
>
[quoted text clipped - 12 lines]
>Thank you
>John

Reply to this Message

VK2KCE - 17 Oct 2007 05:30 GMT

Gord,

As a older struggling Excel user, I do have difficulty following your
solution, sorry!

This is what I did:

1. I formatted the cell which was displaying the 0.00, and now displays 0.
2. I then copied an empty cell to the position which displayed 0, but after
copying the empty cell it now displays a blank.
3. From there I am lost! I am not too sure what you mean by "select to range
of numbers and Edit>Paste Special (in place)>Add>Esc"

Sorry for being so thick!
John

: Typically this is caused by the numbers being text and not real numbers.
:
[quoted text clipped - 20 lines]
: >Thank you
: >John

Reply to this Message

Dave Peterson - 17 Oct 2007 14:05 GMT

I'd try it again.

It sounds like you didn't use Gord's suggestion of Paste Special and clicking
Add.

That Add portion is very important.

> Gord,
>
[quoted text clipped - 38 lines]
> : >Thank you
> : >John

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 17 Oct 2007 15:13 GMT

Should have read "select THE range of numbers"

Also I left out the OK part.

Edit>Paste Special>Add>OK>Esc.

Maybe I'm getting too old for this<g>

Gord

>I'd try it again.
>
[quoted text clipped - 45 lines]
>> : >Thank you
>> : >John

Reply to this Message