| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine 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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine cells with text formatting
PERFECT!!!!
Thank you sooooo much!!!! "Ron Rosenfeld" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine cells with text formatting
On Wed, 21 Feb 2007 17:16:00 -0800, o1darcie1o
wrote: PERFECT!!!! Thank you sooooo much!!!! "Ron Rosenfeld" wrote: 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 You're welcome. Glad to help. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I combine text from several cells into one? | Excel Discussion (Misc queries) | |||
| Combine text data from 2 cells | Excel Discussion (Misc queries) | |||
| How to combine 2 cells' text into 1 cell | Excel Discussion (Misc queries) | |||
| combine text of multiple cells | Excel Worksheet Functions | |||
| How to combine text from multiple cells? | Excel Worksheet Functions | |||
Linear Mode
