I want to input a number into a cell
say for example: 1,515,199,455
and have Excel automatically truncate the last 6 digits off
so the number ends up: 1,515

Can this be done?

Thanks,