URGENT! Please help me...

E

eylul

Hi everyone,

I have a strangeproblem. I tried to solve but couldn't. Even didn'
understand why it happens.
I copied result of an access query and pasted it to an excel colum.
Formatted all the cells as number. But when I want to sum, result i
false. It doesn'n sum all of them. Why I don't now
 
D

DNF Karran

Some of the values are being read as text (is usually the case anyway)
Try:

=SUM(--A1:A10)

and array enter with shft+ctrl+ente
 
J

JE McGimpsey

One possibility is that the numbers were pasted in as Text. Changing the
number format for Text has no effect.

You can coerce text to actual numbers by copying a blank cell, selecting
your data and choosing Edit/Paste Special, selecting the Add and Values
radio buttons, then clicking OK.
 
B

Bob Flanagan

Make the column of numbers real wide. Are they left justified? If so they
are text entries, not numbers.

To convert to numbers, type a 1 in a blank cell and copy it. then highlight
the "text numbers". Do an Edit, paste special, values, multiple.

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Top