Truncating whole numbers - diplaying thousands instead of full num

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top