formula to eliminate the digits to the right of the decimal

[mknispel]

I am trying to concatenate two cells. My problem is the numbers are formatted ##.########### I would like to find a way to concatenate just the whole #'s preceeding the deceimal. can that be done?

[NBVC]

Maybe...

=INT(A1)&INT(A2)

This concatenates the integer part of the numbers of cells A1 and A2, you can add space, or dash, or whatever in between, like =INT(A1)&" "&INT(A2)

[teylyn]

Hello,

you can use

=int(A1)

to return only the integer part of a number.

cheers,

[mknispel]

Thanks that did it.