USAGE OF TO AND BY IN P&L

Excel 735 views 1 replies

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".

Replies (1)

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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register