How do I retain leading zeros in a cell when I combine the values of two cells with =A&C

[GannonJ]

Hi,

I have managed to retain leading zeros in a cell by formatting the cell and selecting Number and Custom and adding the maximum number of zeros I want to have in front of the number in the cell i.e. 000002.
I want to have another cell in the spread sheet which contains the value 35394000002 using the formula =A24&B24.
When I use this formula I get 353942. How can I retain these zeros?

Thanks in advance.

[TMS]

=TEXT(A24,"000000")&TEXT(B24,"000000")


Regards, TMS