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
- SEC 54 OF IT ACT
- Form 26QB for TDS on property
- Where to show the RCM on Rent paid to unregistered landlord
- Is Aadhar PAN linking required for opening bank account?
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- BLOCKED-INELIGIBLE GST CREDIT
- Amendment of September 2021 Invoice
- RCM - commercial rent paid to URP under GST
- Offsetting interest income against derivative trading losses
- Whether still royalty
- Input credit reversal for the FY2023-24
- Regarding Form 15CA & CB
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding Resignation by Auditor from Pvt. Ltd.
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
