Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom formating of cells
Try custom format like
$ 0, $ #.00, etc Note the trailing comma In Google the search fro <excel format thousands yielded over 1 million hits. The first of these was: http://j-walk.com/ss/excel/usertips/tip017.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dale" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom formating of cells
Dale
Custom $#,#00, will show 23,000,000 as $23,000 Note: the value is still 23,000,000 Gord Dibben MS Excel MVP On Wed, 28 Feb 2007 12:36:13 -0800, Dale wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom cell formating | Excel Worksheet Functions | |||
custom formating a cell | Excel Worksheet Functions | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
Help formating Cells | Excel Worksheet Functions | |||
Custom formating won't work | Excel Worksheet Functions |