Truncating whole numbers - diplaying thousands instead of full num
 

I am trying to show numbers in a spreadsheet as thousands instead of the
whole number. i.e. shw 3,000,000 as 3,000 - I cannot find a function that
allows me to dothis. I need to apply the format to the entire worksheet but
not loose the entire original number.

Truncating whole numbers - diplaying thousands instead of full num
 

One way:

Format/Cells/Number/Custom 0,


In article ,
Reez wrote:

I am trying to show numbers in a spreadsheet as thousands instead of the
whole number. i.e. shw 3,000,000 as 3,000 - I cannot find a function that
allows me to dothis. I need to apply the format to the entire worksheet but
not loose the entire original number.