View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Reez Reez is offline
external usenet poster
 
Posts: 1
Default 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.