Hmm Stuck...

D

DB

I have a file on excel that contains many text entries of peoples names.....

A10 has Ken in it
A11 has Bill in it
A12 has Alan in it etc etc etc....

I want to copy these names over to K10
K11
K12..............

The first column is set for text......but i tried the autosum and told it
that K10 = A10,,,,i thought it would just copy the text of the persons name
but it didnt, it just has =SUM(A10) in the cell.

What am I doing wrong?

I'm sure there must be a simple solution but i'm stuck and can't find it.
Can you put me out of my misery and tell me what i'm doing wrong.

Many Many thanks

Dave :))
 
P

Pete_UK

The cell K10 is probably formatted as text - use Format | Cells |
Number (tab) and select General. Then enter a new formula:

=A10

"Ken" should appear, and if you type a different name into A10 then K10
will display the new name. SUM( ) is used to add together the (numeric)
values of cells in a range, and is totally inappropriate here.

Hope this helps.

Pete
 
D

DB

You could be right Pete.....but me thinks i'll stick to one group instead of
shouting at the whole world...

Thanks again

Dave :)
 
P

Pete_UK

I think you'll find that most people who provide solutions read all the
groups, anyway, so you don't need to post in several - this will save
YOU time, as well, as you only need to read responses to one thread,
rather than several.

Pete
 
Top