Format affects the display, not the value of a cell. In particular, if
the cell was text orignally, changing the format to a numeric format
will not change the contents from text to a number.

What value does =COUNT(F19:F22) return? If it returns 1 instead of 4,
then you should try the suggestion of Gary's Student, instead of
dismissing it out of hand.

Jerry

RedHeadedMenace wrote:

did not work. I'd reformatted cells to be both currency and number, and
neither worked then either. But cell props do show formattign worked so no
text confusion.

(multiplying got me the same numbers, btw, but still no correct sum :-( )

Also need to mention this is only the first section of this doc I started on
-- there are many more that will be identical in scope (i.e., insert row,
copy cell into new row, sum number range) so I don't really want ot have to
hand enter the numbers.

"Gary''s Student" wrote:


Let's make sure that Excel knows that you are dealing with numbers:

1, in an un-used cell put 1.
2. copy this cell
3. select the cells containing the numbers $11,087 thru $1,211
4. do an Edit Paste Special and check the multiply button

This will fix the situation is Excel is confused numbers vs text.
--
Gary''s Student


"RedHeadedMenace" wrote:


Excel 03
OK, I'm trying to sum numbers a column. This is exact representation, cells
F19 to F22:

$11,087
$3,400
$2,400
$1,211

I sum into F23 and get the result of only F19 *$11,087.* F23 cell formula
shows as
=SUM(F19:F22)

This is a sheet I downloaded. I added a row (F21) to insert the $2400.
When first sum action didn't work, I thought maybe it was based on cell
format, so I reformatted to label them currency (this shows in cell
properties), so it's not an issue of cell format standardization.

Also, I copied the numbers from F column to a new one and pasted as *Special
-- values only* and STILL get only the result of the top #, $11,087.

WTF??? and What can I do????