Thanks for the quick reply Rick, i also would like to ask what if the numbers
(both integer and decimal) are in 1 cell..?

"Rick Rothstein (MVP - VB)" wrote:

I'm not really "satisfied" with this one, but it does work. If your two
numbers are in A1 and B1...

=IF(LEFT(A1,2)="0.",MID(A1,2,99),A1)&IF(LEFT(B1,2) ="0.",MID(B1,2,99),B1)

Now the above is a completely general solution; however, if A1 **always**
contains an integer, the formula can be simplified...

=A1&IF(LEFT(B1,2)="0.",MID(B1,2,99),B1)

Rick


"badongt" wrote in message
...
Numbers show an extra zero "0" before the decimal point that changes the
display value whenever i do a concatenate with an integer..Is there a way
to
remove that extra "0" so it would display the concatenated value
properly???