Hello everyone,

I'm new the boards, and just started a new job that requires a lot of macros.

My first question is,

Column A has a goes from 1-950 in each row respectively.

For instance,

Row 1 under column A = 0
Row 2 under column A = 1
and so on...

I want to add "00000" to the front of each number and ".jpg" to the back of each number.

Final Result

Row 1 under column A = 000000.jpg
Row 2 under column A = 000001.jpg
and so on...

If anyone knows of a easy approach to do this instead of manually doing through each row, let me know!

I appreciate it greatly

-JEsse