| 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 |
|
#2
|
|||
|
|||
|
Hi
I'm guessing that the cells contain only 0 but are formatted to display 00. Try something like this: =TEXT(C6,"00")&TEXT(C7,"00")&TEXT(C8,"00") Andy. "kier" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
You already asked that yesterday and you got answers too
-- Regards, Peo Sjoblom "kier" wrote in message ... 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 |
| Reply |
| 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 | |||
Hybrid Mode
