Concatinate with number format

Originally Posted by CANAPONE

Hi.

try to add a zero ad the end of your formula.

=if(a2=<a1, concatenate(a2,a1), concatenate(a1,a2))+0

Hope it helps

Now that worked! Thanks, I guess it takes a simple +0 at the end, who would of knew!

Thanks again