I have three columns of existing data.

Column A I want to put "PU" before everything in that column.

Column C&D I want to put "." before that last two digits. These are dollar amounts but that text file they came from had no decimal before the cents. I tried to make it go to 2 decimal places but as you probably know that just added .00 to every number and that is not what I need.

This could be done manually but doing it to 110,000+ cells for each column would take a bit of time.

I am assuming there is a simple way to do this, but my excel knowledge is severely lacking.

Thanks ahead of time.