1.) "&TEXT(Reference cell," #,##0 ;")
="Type the characters you want"&TEXT(A1," #,##0 ;")
How to use it:
Say, A1 cell has got a formula and it computes and gives me the output of an amount in simple numerics, say, 154358.
Now, I want to be presented in Rs.
Here is how I will use the formula
="Rs."&TEXT(A1," #,##0 ;")
Output
Rs. 1,54,358
2) Sometimes, the numbers don't get populated in accounting format i.e. -100000 as (100,000)
a) For that, go to the format cells (Ctrl + 1)
b) In the custom format, paste the following string in the input box
_ * #,##0.00_ ;_ * (#,##0.00)_ ;_ * "-"??_ ;_ @_
c) And click Ok
