URGENT! Please help me...

  • Thread starter Thread starter eylul
  • Start date Start date
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
 
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
 
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.
 
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
 
Back
Top