And all new users know the difference between empty cell and a cell that
looks empty. Yep, you bet.
--
** John C **

"Peo Sjoblom" wrote:

But then it is not empty, I said empty cells, cells with formulas are not
empty

--


Regards,


Peo Sjoblom

"John C" <johnc@stateofdenial wrote in message
...
Type ="" into a cell, then, copy that cell, and paste special with your
range, doesn't work.
--
** John C **

"Peo Sjoblom" wrote:

Well if you are unsure if the cell contains hidden characters then you
should be unsure that the cell is formatted as text as well so the zero
wouldn't help much in that case. The fastest way otherwise would be to
make
sure the numbers seen as text are formatted as general or numbers then do
datatext to columns and click finish

--


Regards,


Peo Sjoblom

"John C" <johnc@stateofdenial wrote in message
...
I said type a 0 in an empty cell, as is a double check that they aren't
adding hidden characters that may be a random blank cell they copy.
--
** John C **


"Peo Sjoblom" wrote:

No need to type 0 into the cell, copy an empty cell is enough

--


Regards,


Peo Sjoblom

"John C" <johnc@stateofdenial wrote in message
...
In your 'practical advice', you forgot to ensure that the cell is
NOT
formatted as text. Because if the cell is formatted as text
(C1:C34),
then
editing the cell by F2 & Enter isn't practical at all.
Practical advice would be to highlight the cells C1:C34, ensure
formatted
as
general (or if preferred, as number). Type a 0 into an empty cell.
Copy
that
cell, then select your range C1:C34, Paste Special -- select Add
and
OK
out.
--
** John C **

"Satti Charvak" wrote:

I'll give a practical advise (One of those clerical problems)

go to cell C1

hit "F2" key and then followed by "Enter" Key

cell c1 is converted to number.


the selection will go to cell c2

Do the above activity 33 more time and you are done
--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Ron Rosenfeld" wrote:

On Sat, 8 Nov 2008 05:54:01 -0800, LionR

wrote:

I set up a formula adding a set of numbers in a column,
e.g.=sum(c1:c34).
The formula is correct but I got a zero as an answer. I set up
the
same
formula in another column and it gives me the correct answer,
e.g.
$2,500. I
tried copying this formula to the first one on the same row.
And
it
returns
$2,500.

What is going on?

Possibly your "numbers" in c1:c34 are text.

What do you get if, in some cell, you type: =istext(c1)

How are the data entered in column C?
--ron