Inserting a Coma in a rows

[mgrigsby21]

I'm trying to insert some coma's @ the end of each number on every row....I have 6000 numbers and do not want to go to each cell and put a coma behind the number. How would I fix the problem to enter it in on everyone.
Example: Trying to get it to look like the first two.

12,
14,
16
18

Any help would be greatly appreciated

 

[Mark W.]

=A1&","

If you don't want the last number in the list to have a comma use...

=A1&IF(LEN(A2)>0,",","")
This message was edited by Mark W. on 2002-04-26 13:06

 

[mgrigsby21]

Where would I enter that formula?

 

[Mark W.]

If your 1st number is in cell A1 enter either of these formulas in B1.