Adding a period to the end of cell contents

[ntallman]

Hi all,

Is there an easy way to add a period to the end of each cell's contents in a particular column? I have a column with over 500 rows and need to add a period to the end of the data in each row. There must be an easier way to this other than manually, perhaps using VBA?

Thanks!
Nathan

[Astroboy142]

Can you give an example?

Right now from what I'm thinking you could put this in a cell ="."

Example would help though

[daddylonglegs]

One way......assumes data in A1:A500....

Put this formula in B1

=A1&"."

and copy down to row 500 (if you place the cursor on the bottom right of B1 until you see a black "+" and then double click that will copy down automatically)

Now copy column B and use Edit > Paste special > values to convert formulas to values

Now you can delete the original column A

[Astroboy142]

there is the =CONCATENATE(....) formula as well

[NBVC]

there is the =CONCATENATE(....) formula as well

The & between the two items is essentially concatenating the items....

[day92]

Here is a macro that will do the trick.

Please Login or Register  to view this content.

Let me know if you have any questions

[ntallman]

Thanks everyone for your replies! I used the =A1&"." formula and it worked like a charm.

Nathan

[studmount]

This helps, but what if you would want the code to pick a worksheet and a column in the worksheet?

[ZinCT]

Can someone help with this. After using excel on and off for 10 years, I now all of a sudden have to hit the period after entering a number to get a whole number. For example if I am in a currency column and type (1,0 then enter) I get ten cents instead of ten dollars. In the past it was reversed in that I had to type (period then 1,0 then enter) to get ten cents and if I typed (1,0 then enter) I would get ten dollars.

Is there a setting I can use to revert back to how it was. I want to type (1,0, enter) and get the dollar amount.

This also works in regular numerical fields. I want to change it back so that I do not have to type a period after entering a number to get a whole number.

thanks

[daddylonglegs]

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.