 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007Combine cells with text formatting
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 [quoted text clipped - 4 lines] >Is there a way to do this? >Thanks in advance! =TEXT(Y2,"0000")&TEXT(Z2,"0000") --ron PERFECT!!!! Thank you sooooo much!!!! > >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 [quoted text clipped - 8 lines] > > --ron >PERFECT!!!! >Thank you sooooo much!!!! [quoted text clipped - 11 lines] >> >> --ron You're welcome. Glad to help. --ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.