Hello,

I have a colleague working with Excel 2000 (it's the Romanian version), and
from time to time she is experiencing this issue:

She is entering numeric values into a column and after that she is trying to
sum all the values in the column (the very well-known SUM formula). Weird is
that the sum does not work on the column, even if she tries all the tricks
in the book, moreover I tried everything I could think of ubt to no effect.
In concrete, I tried changing the format of the fields to numeric, tried to
copy the values to a different location (only values, no formats at all),
but the sum formula does not do the total nevertheless.

Curiously enough, I tried entering all the values again (in a parallel
column), and the total is working this time -- in fact, this is the only
solution I could find until now, however inconvenient this is.

Do you know a solution to this issue I've described ? And maybe a
description of the cause.

Thank you,
Emil.