Copy data as is seen - ajit

[Ajit Munj]

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.

 

[dlw]

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

 

[Pete_UK]

Try this:

=TEXT(A1,"000000")

if your formatted number is in A1. Copy down to row 1000.

Hope this helps.

Pete

 

[Jim May]

Format the Destination Range FIRST as Text;
Then (and only then) Copy and Paste to the Destination Range.
That will likely work...

 

[Dave Peterson]

You could use a formula:

=text(a1,"000000")

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.

 

[Kevin B]

Insert a helper column to the right of the column containing your 4-digit
numbers and enter the following formula:

="00"&A1

Changing A1 to match the cell with the first value. Then copy the formula
down the column to the last row.

Copy the entire helper column, move to the starting cell of the target
location and click EDIT in the menu, select PASTE SPECIAL and click the
VALUES option button.

The results of the formula are pasted to the target location as a 6 digit
text string with 2 leading zeroes. You can now delete the helper column with
the original formulas as it is no longer needed.

When you format a number it only changes the display of the number and not
its value, which is why you can't copy the value as viewed.

Hope this helps.