| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need help cancatenating numerical values
I am trying to combine values from many cells into one, but the values have
zero places that get lost after combining them. For example, I need to combine "00"&"00"&"01" so that the new value reads 000001. But when I do this with the concatenate function, I lose the 1st zero in every cell so that it reads 001. Can anyone help? Thanks! -Kier |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
| Assign numerical values to text codes | Excel Worksheet Functions | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| How do I stop excel replacing numerical values with the date? | Excel Discussion (Misc queries) | |||
| MS Excel should allow you to format numerical values to thousand. | Excel Worksheet Functions | |||
Threaded Mode
