View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dale Dale is offline
external usenet poster
 
Posts: 92
Default Custom formating of cells

I have a number in a cell that is in whole numbers that I needs to be
reported in $,000. In the Format cells menu on the nubers tab there are
several (###.00) type cells. I am importing a lot of data that is in million
of dollar and I want to convert to be reported in thousands. Is there a
formula/conversion I can use in the custom section on the tab to accomplish
this task?

Thanks

Dale