SV: Re: Excel sum problem

[Guest]

I had already checked that the cell was numbers
If the cell has the format numbers, and it says 50 in it, I would like excel to handle it like the number 50 and not as something else
This must be a bug in excel that can cause many calculation errors
The copy paste special solution seems cumbersome if u are handeling really big data files

/n

 

[Peo Sjoblom]

Because you want it to be numbers doesn't necessary means it will be
numbers, use a formula and test,
assume the data is in column A, copy down the following

=ISNUMBER(A1)

if any of those will return FALSE it is text.

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

I had already checked that the cell was numbers.
If the cell has the format numbers, and it says 50 in it, I would like

excel to handle it like the number 50 and not as something else.

 

[Peo Sjoblom]

It's impossible to see what you are posting this as an answer too, if you
want to make it easy
for people who don't use the web forum you should quote the message you
answer.
I think it is irritating that excel guess what a value is like when you
enter 4-2 and it will default
to a date but I have never heard excel guess that something that is entered
as a number turns
to text. The reason it is text is that it is text when it is pasted and
nothing you do to change the format
will do change that except to force a calculation

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Ok, that will tell me that it is not a number.....
But this is the problem, if I inport something into a cell then I can

accept that excel tries to guess what format it should be, and off course do
mistakes sometimes....

But, if I have a cell with something in it (in this case a 5 and a 0) and

afterwords change the format to numbers for that specifiq cell then I WANT
excel to treat it as an number, if it fails to do so I would consider it a
serious bug/error.