If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Having trouble with one column formula
I can't figure out what I am doing wrong. I am adding
figures in a columns. I've entered the same formula (with the appropriate column letter) and it works fine except for column M. The formula I am using is =SUM(M3:M45). It adds the column correctly but the total is followed by -Jan. I can't seem to get rid of the -Jan. I can't figure out where it is coming from. The column headings are months, but column M happens to be August and as I have previously stated, this is the only column that I am getting something other than just the correct total. Thanks for any help you can provide. |
#2
|
|||
|
|||
Having trouble with one column formula
Hi Deb!
It looks like a formatting problem. Check the formatting for the cell in column M (Select the cell, then select Cells from the Format menu) and change to the format you use in the working cells. You could also copy the formatting from a working cell, by select a working cell and click on the Format Painter button, then click on the cell in column M. Stefan Hägglund Microsoft "Deb H" wrote in message ... I can't figure out what I am doing wrong. I am adding figures in a columns. I've entered the same formula (with the appropriate column letter) and it works fine except for column M. The formula I am using is =SUM(M3:M45). It adds the column correctly but the total is followed by -Jan. I can't seem to get rid of the -Jan. I can't figure out where it is coming from. The column headings are months, but column M happens to be August and as I have previously stated, this is the only column that I am getting something other than just the correct total. Thanks for any help you can provide. |
#3
|
|||
|
|||
Having trouble with one column formula
Deb
Check the formatting of the cell in which the formula resides. Perhaps a custom setting of #,##0.00 "-Jan" or similar? Gord Dibben Excel MVP On Tue, 25 May 2004 20:38:33 -0700, "Deb H" wrote: I can't figure out what I am doing wrong. I am adding figures in a columns. I've entered the same formula (with the appropriate column letter) and it works fine except for column M. The formula I am using is =SUM(M3:M45). It adds the column correctly but the total is followed by -Jan. I can't seem to get rid of the -Jan. I can't figure out where it is coming from. The column headings are months, but column M happens to be August and as I have previously stated, this is the only column that I am getting something other than just the correct total. Thanks for any help you can provide. |
Thread Tools | |
Display Modes | |
|
|