Assuming you have the cells pre-formatted to your special format, then try
Copy PasteSpecial Values, instead of just plain Copy Paste, as that
copies the formatting as well as the values.

Vaya con Dios,
Chuck, CABGx3



"Newbie" wrote:

This worked great! Thank You Gary, now how can I copy from column A and paste
to column B and make the same action occur?
--
Arthur


"Newbie" wrote:

Can someone tell me step by step how to make text entry appear in a cell as a
suffix automatically after I make an entry...ex....type 123 in cell A1..I
want sm.jpg to automatically thereafter....123sm.jpg. How can I formulate the
entire column. Can anyone help?
--
Arthur