Automatic fill incriment

[timboellis2031]

I have a CSV i need to use to upload to my SQL database however I want to tell my SQL database where my images on the server are and have names all my images:
http://www.excelforum.com/images/1.jpg
http://www.excelforum.com/images/2.jpg
and so on up to 500

however is there any way to get it to fill in by dragging the first cell and to get it to auto fill the closest i cn get is by using the first cell as
http://www.excelforum.com/images/1

the it works but i then loose the extention

So can any one help with either adding the extention to all the cells or allow me to auto fill to 500

[shg]

Format the cell as @".jpg" and drag away.