|
| 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
June 16th, 2004, 07:34 AM
|
|||
|
|||
SUM error - displays a Date instead of SUM calculation
In all my rows and columns where i've put a SUM calculation for that row or column (ie as a Total), it shows a date (eg "Jan - 2003") instead of the sum of the cells.
|
|
#2
June 16th, 2004, 08:26 AM
|
|||
|
|||
|
SUM error - displays a Date instead of SUM calculation
Phoebe H wrote:
In all my rows and columns where i've put a SUM calculation for that row or column (ie as a Total), it shows a date (eg "Jan - 2003") instead of the sum of the cells. Phoebe, The cells are lost likely formatted improperly. Highlight the cells, click on Format|Cells, on the number tab select number under category. tim
|
|
#3
June 16th, 2004, 08:49 AM
|
|||
|
|||
|
SUM error - displays a Date instead of SUM calculation
Thanks Tim. An easy fix. I'm learning!
Phoebe "Tim Otero" wrote: Phoebe H wrote: In all my rows and columns where i've put a SUM calculation for that row or column (ie as a Total), it shows a date (eg "Jan - 2003") instead of the sum of the cells. Phoebe, The cells are lost likely formatted improperly. Highlight the cells, click on Format|Cells, on the number tab select number under category. tim
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
