Formatting a Number with leading zeros

I have a column in Excel with numeric values such as:

11405
11490
11516
11859

I need a way to convert to a 20 digit number (add 15 leading zeros)......

00000000000000011405

I'm certain there's an easy way for this..........

Thanks in advance.......

Like this perhaps?

Select column and right-click one of the highlighted cells, and then click "Format Cells."

Click the "Number" tab, and then click "Custom" on the left side of the "Format Cells" window.

Click the number "0" under "Type," and then type the number of zeros indicating the maximum number of digits that you plan to enter for a single item in your spreadsheet. For example, type "00000" if you would like each number to be five digits long.

If you type the number "123," Excel will add leading zeroes to make the number "00123."
Click "OK" to save the custom format.

Alf

Thanks for the quick response. Unfortunately, I don't think this will work for me..........

The cell displays 00000000000000011405.............but when I highlight the cell.........11405 is the value.

This excel file will be used to import transactions into an accounting package. I know from expereince my integration tool will not 'see' the 0000000000000000 leading zeros and will import a value of 11405.

I tried converting to 'text' but, of course it doesn't stay numeric - leading zeros go away.

I think I need to format the cell as a string and then programatically add the 15 leading zeros (leading zeros is always 15)......

Any other thoughts?

Actually I just solved my problem.

I copied the values of the custom formatted numbers (suggested by Alf) into notepad. Notepad picked up the leading zeros. I then copied back into a row formatted as 'text' and the leading zeros copied over nicely.......

Probably not eloquent.but it worked..........thanks to Alf for his assistance

I tested Pepe's solution - also works quite nicely.........Thanks