| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate & custom formats
I have a cell with a custom format of 0000 so that a 1 will return 0001 in
the cell. I am trying to use the concatenate function to combine multiply cells into one. When I do this I lose the zero place holders, how can I retain my format? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenate & custom formats
=text(a1,"0000") & " how are you this day: " & text(b1,"mm/dd/yyyy")
Jeff Davis wrote: I have a cell with a custom format of 0000 so that a 1 will return 0001 in the cell. I am trying to use the concatenate function to combine multiply cells into one. When I do this I lose the zero place holders, how can I retain my format? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate & Number Formats | Excel Discussion (Misc queries) | |||
| Concatenate 2 different number formats | Excel Discussion (Misc queries) | |||
| How to get different text formats in a concatenate function | Excel Discussion (Misc queries) | |||
| number formats after concatenate | Excel Worksheet Functions | |||
| number formats after concatenate | Excel Worksheet Functions | |||
Linear Mode
