WORKED GREAT!!!

THANKS!!!!

"Teethless mama" wrote:

format cell as: 85000000


"Chip" wrote:

Howdy from Oklahoma!!

I am not an excel person so i am having trouble with this situation.

We have a program that builds a .csv file with our payroll data that is sent
to our home office for importing into the corporate payroll system.

Now for the situation, our home office has made some changes to the
accounting system and the charge# (i.e. 77074) that we used to identify what
account the payroll time needed charged to. this charge# now is a 8-digit
number with a '850' added to the original charge# so it now it should look
like this "85077074" with the 850 in front of the original 77074.
Is there any way I can build a macro or some other wizard that i can create
for our payroll people here that can take the column that has the charge# and
do something like adding 85000000 to each charge# in the column? or if it
can just add the 850 to the beginning of each charge#???

Again, I am not an excel person so this may be a Simple Fix but i just do
not know enough about excel to set up something like this...

As Always, THANKS IN ADVANCE!!!!
Chip