instead of copy, use the formula =text(a1,"000000")

"Ajit Munj" wrote:

I have column with 1000 values of 4 digits which I want as 6 digit with 2
leading zeroes. I changed the format and did it. Now I want to copy them in
another range as 6 digit (as it shows in cells) as a text. But it does not
get copied. Pl. suggest me the way out.
--
Knowldege is Power