G Guest Jul 7, 2005 #1 How do I create a custom number format to return thousands e.g. if the value is 1000 the format shows 1
How do I create a custom number format to return thousands e.g. if the value is 1000 the format shows 1
G Guest Jul 7, 2005 #2 Under Format -> Cells in the Custom format box type #, (make sure you put the comma in). This will only show the thousands part, note that it will round numbers like 2598 up to 3 instead of 2. Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com
Under Format -> Cells in the Custom format box type #, (make sure you put the comma in). This will only show the thousands part, note that it will round numbers like 2598 up to 3 instead of 2. Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com
D Damon Longworth Jul 7, 2005 #3 Try this custom number format: 0, Or: #, -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com
Try this custom number format: 0, Or: #, -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com
D Debra Dalgleish Jul 7, 2005 #4 Select the cells Choose Format>Cells On the Number tab, select the Custom category In the text box, type: #, Click OK
Select the cells Choose Format>Cells On the Number tab, select the Custom category In the text box, type: #, Click OK
G Gary Brown Jul 7, 2005 #5 Try the following custom format:- #,###, This will display 1,523,754.25 as 1,524 Add how you want negative numbers to display at the end by sepearting the codes with a semi colon (ie in brackets minus sign etc)
Try the following custom format:- #,###, This will display 1,523,754.25 as 1,524 Add how you want negative numbers to display at the end by sepearting the codes with a semi colon (ie in brackets minus sign etc)
G Guest Jul 11, 2005 #6 Thank you Andrea Jones said: Under Format -> Cells in the Custom format box type #, (make sure you put the comma in). This will only show the thousands part, note that it will round numbers like 2598 up to 3 instead of 2. Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com Click to expand...
Thank you Andrea Jones said: Under Format -> Cells in the Custom format box type #, (make sure you put the comma in). This will only show the thousands part, note that it will round numbers like 2598 up to 3 instead of 2. Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com Click to expand...
G Guest Jul 11, 2005 #7 Thank you Debra Dalgleish said: Select the cells Choose Format>Cells On the Number tab, select the Custom category In the text box, type: #, Click OK Click to expand...
Thank you Debra Dalgleish said: Select the cells Choose Format>Cells On the Number tab, select the Custom category In the text box, type: #, Click OK Click to expand...
G Guest Jul 11, 2005 #8 Thank you Damon Longworth said: Try this custom number format: 0, Or: #, -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com Click to expand...
Thank you Damon Longworth said: Try this custom number format: 0, Or: #, -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com Click to expand...
