Hi,
I have made a column Reg Id. which is formatted to 4 Digit No. (when i enter 1 it takes 0001 and 333 it takes 0333)

but when i select any cell or copy values to diff columns,it copies just the no.i entered and not the whole 4digit no.(while coping it will copy 1 or 333 )
what should i do to get this 4 digit no. to use in any other sheet/mail merge ?

(in mail merge,the reg id field is included where i wish to print 4digit no. but it will take the nos and omit the prefix zeros )