Merging cells in excell

Closed
Ady - Feb 23, 2010 at 03:30 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 23, 2010 at 03:55 AM
Hello,
I have inserted a 0 before a number in one cell then i ahve merged this cell with another the result i get is losing the 0
example 1234 merged with 02 results in 12342?
I need to keep the 0

Regards

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 23, 2010 at 03:55 AM
How are you merging ? Most probably the "02" is actually 2 and you have just formatted it to make it appear like 02

If that is the case you have to use Text

Lets say A1=1234
B1=2 (that you have formatted to make it appear like 02)
then in C1 , you can use

=A1 & Text(B1, "0#")
0