Keeping the "0" as the start of a string of numbers

[sprtfan34]

Normally I use the "'" apostrophe to keep the "0" at the start of a string of numbers, but I am impurting the sheet into an excel tool which is dropping the ' and the subsequent "0". Is there another way to keep the "0" in the string.

Thank you,
Jerry

 

[Joe4]

How/where exactly are you entering the value?
If it is entered as Text, and not a Number, it should maintain the leading zero.
We may need to know more about how this "Excel tool" works.

 

[JoeMo]

This returns a text string, not a number:

Excel Workbook
	C	D
1	123	0123
Sheet2

 

[sandy666]

another way (with single 0)

=BASE(A2,10,LEN(A2)+1)