Prefix Rs. in Excel with numbers
This query is : Resolved
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.
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
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
- ITR 2 Short Term gain & Long term gain
- Itr 1 processing
- Reporting Income under Section 44ADA
- Off Market debit and credit transaction
- ITR returnFY25-26
- Share accounting-->fifo - capital gain - period as per fifo?
- ITR validation error - Balance sheet is not filled
- Form 10E u/s 89(1). Need clarification because experts opinions differ !!!!
- Bank Accounts in Balance Sheet for ITR 3
- INCOME TAX ON REDEVELOPEMENT OF FLAT
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
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
