I have large numbers in Excel, i.e. 48,760. I want to display it as 48. The
column heading will indicate the number is in thousands. I can't find a
formula to round the number and only display the amount in thousands.

I understand the "round" function but can't find a suitable truncating
function.

any help?