View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Combine cells with text formatting

On Wed, 21 Feb 2007 17:03:21 -0800, o1darcie1o
wrote:

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!


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

--ron