Combine cells with text formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell with numbers. I need them to be 4 digits long, so they're
formatted as custom, using 0000 as the custom format (the numbers have
leading 0's).
Now I'm trying to combine this cell with another cell, but it won't keep the
leading 0's, no matter what I change the format of the destination cell to.
I'm just using =y2&z2, & I tried using =concantenate but neither are working.
Is there a way to do this?
Thanks in advance!
 
I have a cell with numbers. I need them to be 4 digits long, so they're
formatted as custom, using 0000 as the custom format (the numbers have
leading 0's).
Now I'm trying to combine this cell with another cell, but it won't keep the
leading 0's, no matter what I change the format of the destination cell to.
I'm just using =y2&z2, & I tried using =concantenate but neither are working.
Is there a way to do this?
Thanks in advance!
Click to expand...

=TEXT(Y2,"0000")&TEXT(Z2,"0000")

--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP, a table with text and numerics 7
Conditional formatting a cell containing "<" 4
Microsoft Excel 2002 1
Cell format 3
concantenate then index match 2
Excel VBA 1
default format for text in cells 3
Format custom number: C-0000-L 2

Back
Top