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
- 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
- Form 26QB for TDS on property
- Where to show the RCM on Rent paid to unregistered landlord
- RCM - commercial rent paid to URP under GST
- Offsetting interest income against derivative trading losses
- TDS NUMBER SURRENDER
- Payable outstanding for years disallowance
- Whether still royalty
- Withholding tax applicabikity for foreign paymenttowqards physio therapy treatment
- 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
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
