=Concatenate(A2,"",C2,"",E2)
or more simply:
=Concatenate(A2,C2,E2)
or even
=A2&C2&E2

But it doesn't look like E2 is formatted as General--or did you type '011 (with
the leading apostrophe)?

You may want something like:
=text(a2,"0000")&text(c2,"0000")&text(e2,"000")



babs wrote:

=Concatenate(",A2,"",C2,"",E2,")

a2 c2 e2 f2
2378 7011 011 =Concatenate(",A2,"",C2,"",E2,")

I am trying to tie together fields that are formatted as general. I am
using the above concatenate formula but keep just seeing the actual formula
and not the numbers that I want to see.

What am I forgetting or putting in wrong???

Thanks,
Barb

--

Dave Peterson