Copy data as is seen - ajit

  • Thread starter Thread starter Ajit Munj
  • Start date Start date
A

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.
 
Try this:

=TEXT(A1,"000000")

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

Hope this helps.

Pete
 
Format the Destination Range FIRST as Text;
Then (and only then) Copy and Paste to the Destination Range.
That will likely work...
 
You could use a formula:

=text(a1,"000000")



Ajit said:
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.
Click to expand...
 
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.
 
Back
Top