HW TO PRINT THIS IN A CELL " TO DEPRECIATION OR TO ANY OTHER EXPENSE" WHEN WE JUST TYPE AN EXPENSE SAY DEPRECIATION.
THIS IS SIMILAR TO PRINT "Rs.10,000" when we type "10,000".
CA B Anand (CHARTERED ACCOUNTANT) (198 Points)
29 June 2010HW TO PRINT THIS IN A CELL " TO DEPRECIATION OR TO ANY OTHER EXPENSE" WHEN WE JUST TYPE AN EXPENSE SAY DEPRECIATION.
THIS IS SIMILAR TO PRINT "Rs.10,000" when we type "10,000".
Santhosh
(CA- Student)
(39 Points)
Replied 02 July 2010
Just follow the below instruction
Select the whole column and go to >>format>>cell>>number>>custom>>
type:Rs.#,##0.00_);[Red](Rs.#,##0.00)
>>press OK