No need for G1 ... do the formatting right in the concatenate formula.

=D1&E1&TEXT(F1,"0000000000")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"AuthorizedUserPF" wrote in
message ...
Hi all;

I am trying to cocatenate three columns of data into 1. No problem , but I
am having trouble trying to get cocatenate to accept leading zeroes. I
have
one spreadsheet where the data is run from Oracle (Peoplesoft) to Excel
and a
standard 10 digit number will come over with leading zeroes. I.E.
0000007899.
When I cocatenate with other columns, the cocatenate accepts the leading
zeroes.
Column a1 = MIS, Column B1 = 1, Column C1 = 0000007899, Cocatenate =
MIS10000007899
Now I have a Spreadsheet where the data must have been sent via CSV, text,
prn.
Column D1 = MIS, Column E1 = 1, and Column F1 = 7899. I used a new column,
G1 to do a = value formula on column F1 , 7899, and custom format as
number
0000000000. The number now displays as 0000007899 in column G1. Now when I
cocatenate Columns D1, MIS, E1, 1, and G1, 0000007899, I get in return
MIS17899. I do I get the leading Zeroes in the cocatenate so I can use it
as
a vlookup value.
Any help will be greatly appreciated
Thanks Phil