| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Combine two cells (numbers) but not add
I have column A of cells containing three digit numbers in each cell.
In column B, I have the same thing cells with three digit numbers. I would like to combine these two numbers into a six digit number. How can this be done? Also, in column B there are several cells with a zero value, so a blank is displayed. How can I make the zero values into three digits or can I leave the zero value as a blank and not affect the six digit number I want to create? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using If to combine answers including text and numbers | Excel Worksheet Functions | |||
| Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
| how to combine numbers with the comma | Excel Worksheet Functions | |||
| Combine Cells | Excel Worksheet Functions | |||
| combine cells | Excel Discussion (Misc queries) | |||
Threaded Mode
