I don't know ..

Going back to your orig. post,
if you had a concat formula in say, D1:
=A1&B1&C1
where A1:C1 contains say: 1, 0, 1
then D1, by now, with the formula working,
should return the text: 101
(D1 shouldn't return: 0)

Is the above what's happening over there,
or did we go out of sync somewhere along the line ?
Pl clarify
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Raff" wrote in message
ups.com...
Hi,
Try widening the col with your concat formulas,
or try formatting the col to wrap text
(Click Format Cells Alignment tab Check "Wrap Text" OK)

Ok, but result in cell is 0 - one single digit. So I made column wider,
I wraped text, but 0 is 0...
Best Regards
Raff