Get instant live expert help on I need help with excel accounting format brackets negative
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi i need the custom format for display of numbers in lakhs with two decimals and negative numbers in brackets. for eg -123456789.00 to be displayed as (1,234.57). Can this be provided
Solved by B. S. in 11 mins
How do you convert a - negative sign into ( ) brackets. I tried going into "Custom" but the drop down does not show ( )
Solved by T. E. in 11 mins
It is an urgent matter so please if anyone can solve this How to set that if the number in the cell is negative to be displayed in brackets no matter how many digits it has? (-1,34) (-3) (-1,6789) 2 6,789. So if the number is positive it is displayed normally but negative in brackets. I tried #,###;(-#,###) but this gives (1,).
Solved by X. H. in 27 mins
Apply Accounting Number Format to the dollar amounts imported into column A.
Solved by V. W. in 19 mins
Apply Accounting Number Format to the range C5:C16. Apply Accounting Number Format to the first row of monetary data and to the total row. Apply the Comma style to the monetary values for the other employees. Underline the last employees monetary values and use the Format Cells dialog box to apply Top and Double Bottom border for the totals.
Solved by X. E. in 30 mins