I have a cell (A1) that has the following formula =A2 & "Kwh Used" This displays as 3753.19371727749 Kwh Used
Cell (A2) is formatted as a number and contains 3753.19371727749 but I have truncated the number to be without fractions therefore displays 3753

Is there a way to display cell (A1) as the truncated number ie 3753

Thanks

Ian