need a formula or advise to custom format of cells

[acsishere]

Dear Friends,

I request your kind help to solve this.

I need a formula or custom format of cells to do like

Please Login or Register  to view this content.

The code (1) should be converted into A0001. i.e. irrespective of number of numerals in col.A, the col.B should be with 5 digits (as mentioned).

Request your kind help.

[XOR LX]

Hi,

Custom Format: \A0000

Regards

[:) Sixthsense :)]

In A2 Cell
1

In B2 Cell

Please Login or Register  to view this content.

Drag it down...

[AndyLitch]

="a" & text(a1,"0000")

[acsishere]

Excellent Friends,

Thanks for lightning & exact response.