Prefix Rs. in Excel with numbers
This query is : Resolved
Bal Krishna Misra
(Querist)
09 May 2008
Dashrath ji
As per your suggestion, Excel not prefix the Rs. before number, kindly clarify.
As per your suggestion, Excel not prefix the Rs. before number, kindly clarify.
K V Subba Rao
(Expert)
09 May 2008
I am afraid, it is not possible to prefix numbers with Rs. If you are however particular to print Rs. before amounts, you may like to adopt the following procedure.
To the left of column in which you enter amounts, insert a new column, adjust its size to 3 and type Rs. For the purpose of heading, merge both the columns (alignment)and type Amount as heading to the column
When you print the Report, it appears as though Rs. is pre-fixed to the amounts
To the left of column in which you enter amounts, insert a new column, adjust its size to 3 and type Rs. For the purpose of heading, merge both the columns (alignment)and type Amount as heading to the column
When you print the Report, it appears as though Rs. is pre-fixed to the amounts
Kamaraj Mani. N
(Expert)
23 June 2010
What version you are using?
Excel 2003 or 2007?
In excel 2007, you can insert Rs. in front your value.
steps to be followed:
1. right click the cell
2. select format cells
3. Select currency category
4. select symbol as "Rs."
Excel 2003 or 2007?
In excel 2007, you can insert Rs. in front your value.
steps to be followed:
1. right click the cell
2. select format cells
3. Select currency category
4. select symbol as "Rs."
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Gst credit note by supplier
- Movement of goods by packers and movers - type of sale - Reg.
- GST on reimbursement of expenses
- Due date for filing return for the partner in partnership subjected to Tax Audit
- Missed uploading GST Invoice
- Query on effect of registration of property
- Gratuity paid to legal heir above 20 lakh is taxable or not
- Wrong CMPo8 file
- Equity Share Sale and Purchase
- Goodwill transfer of deceased father’s firm – ICAI applying a 27.04.2026 cut-off to the 3 year limit
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
- How to get money back from delisted company
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
