Retain Zero in front

[tek9step]

Hello

I few values in column B which start with Zeros and on a vb form those (8 digit)values are being picked up by drop down box to be place in a new sheet. when copied over to new sheet it is removing the zeros in the front. The output sheet is a txt file and i would to retain the zeros in the front of the value.

e.g

00789876
06784367
00007539
50667298
00725637

output appearing
789876
6784367
7539
50667298
725637

How can i stop this.

Thanks

regards

[rwgrietveld]

The first list are TEXT values.

Copying these will result in a VALUE and then the zero's are not retained.

Yo can prevent this by copying VALUES and NUMBER FORMAT in the paste special options.

[tek9step]

Hi rwgrietveld

It still is removing zeros in front even after copying over column B as values number format.

Regards

[rwgrietveld]

Are you sure that you used the right option. See attachement.

What is the current format of the cell?

[tek9step]

Yes done the same no result

I have attached a sample file..

regards

[pike]

perhaps something like

Please Login or Register  to view this content.

[tek9step]

Hi Pike

Could you please tell me how and where to place this code ?

Please Login or Register  to view this content.

regards

[pike]

The code is for write to a txt file
you may only need to use "custom format" the cells to 00000000
it hard to say what you are doing from the snipet of workbook code

[rwgrietveld]

I'm confused,

Are we still discusing the same topic here. This is a EXCEL GENERAL topic, not a PROGRAMMING topic.

Next: your sample WB does not contain a UserForm or any other code. Please explain.

[tek9step]

Hi rwgrietveld

yes we are still discussing the same problem of Zeros in front.. I was just trying to find a way to change the source without using any code (as special paste value number format didnt work) but pike has provided with a solution based on the question i raised.

So this problem has fallen in between general & programme.

I am ok for the moderator to move it to programming.

regards