=(TEXT(A3,"00")&" "&TEXT(B3,"00000")&" "&TEXT(C3,"000"))
--
David Biddulph

"RMP" wrote in message
...
Please help.

I have a large spreadsheet to format. The first 3 columns contain parts of
an account number. The first column containing 2 digits (00) the 2nd
containing 5 digits (00000) and the 3rd containing three digits (000) ie.
00
00000 000.

I have used the following formula to migrate the contents into 1 column,
=(A3&" "&B3&" "&C3) in the hope that it would form a number like this
00 00000 000.

The problem is some of the account numbers begin with zeros. so 01 00435
020
shows as 1 435 20. I have formatted the cells to show a custom number,
pasted
the values rather than the formula in the cells and nothing will work.

Any help would be very much appreciated.

Thanks
--
RMP