A abdulncr Member Mar 13, 2013 #1 HI, I have below custom to display B instead of billion an M and instead of million. could you tell me how to add trillion also to this [>999999999.999]#.0,,, _-"B";[>999999.999]#.0,, "M";#,##0 _M Regards Abdul
HI, I have below custom to display B instead of billion an M and instead of million. could you tell me how to add trillion also to this [>999999999.999]#.0,,, _-"B";[>999999.999]#.0,, "M";#,##0 _M Regards Abdul
Luke M Excel Ninja Staff member Mar 13, 2013 #2 Based on the note in the last item here, you can only do 2 conditions. =( http://www.ozgrid.com/Excel/CustomFormats.htm Similar question I found was here: http://www.excelforum.com/excel-general/674702-conditional-custom-number-format.html Looks like you can either try to use a formula to get the correct look, or do some VBA tricks. Sorry I don't have a better answer. =/
Based on the note in the last item here, you can only do 2 conditions. =( http://www.ozgrid.com/Excel/CustomFormats.htm Similar question I found was here: http://www.excelforum.com/excel-general/674702-conditional-custom-number-format.html Looks like you can either try to use a formula to get the correct look, or do some VBA tricks. Sorry I don't have a better answer. =/
A abdulncr Member Mar 15, 2013 #3 Hi Luke, thanks for the link. sorry i am unabe to find the solution in the link provided. any one have any...even in the VBA Regards Abdul
Hi Luke, thanks for the link. sorry i am unabe to find the solution in the link provided. any one have any...even in the VBA Regards Abdul