Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add a comma following a series of numbers
I have two thousand rows with unique account numbers. I would like to add a
comma after each number without having to do it manually. Is there a way to add a comma (,) automatically into each cell so that it's located after the number? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add a comma following a series of numbers
First account number is in A1, say
In B1 use formula =A1&"," Copy down the column by double clicking B1's fill handle (small solid square in lower right corner when cell is selected Select all the B cells; use Copy command; with all B's still selected use Edit | Paste Special with Values specified Now formulas are values and you can delete column A best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "ffrigo" wrote in message ... I have two thousand rows with unique account numbers. I would like to add a comma after each number without having to do it manually. Is there a way to add a comma (,) automatically into each cell so that it's located after the number? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add a comma following a series of numbers
Select the cells and:
Format Cells... Number Custom General"," -- Gary''s Student - gsnu200856 "ffrigo" wrote: I have two thousand rows with unique account numbers. I would like to add a comma after each number without having to do it manually. Is there a way to add a comma (,) automatically into each cell so that it's located after the number? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comma Delimited Numbers | Excel Discussion (Misc queries) | |||
how to combine numbers with the comma | Excel Worksheet Functions | |||
How do I export data from Excel as a series of comma-separated val | New Users to Excel | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
comma align numbers | Excel Discussion (Misc queries) |