HOW TO GET FIGURES IN LACS AT THE CALLED CELL IN EXCEL
This query is : Resolved
26 January 2008
HI to all!!
Kindly make me aware whether there is any command by which i can automatically convert the figures in LACS /THOUSANDs
e.g suppose in a particular sheet containig profit and loss account the figures of sales is 1925892.00 now in the comparative sheet if i m calling the figures from p&l, i want the called figure would automatically rounded of to in lacs i.e. as 19.26
Kindly make me aware whether there is any command by which i can automatically convert the figures in LACS /THOUSANDs
e.g suppose in a particular sheet containig profit and loss account the figures of sales is 1925892.00 now in the comparative sheet if i m calling the figures from p&l, i want the called figure would automatically rounded of to in lacs i.e. as 19.26
26 January 2008
You can set macro command for your auto conversion of Rupees in lakhs. Kindly refer the help menu in Excel for creating macros.
26 May 2010
Thanks1
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
- Treatment of Pension ?annuity returns on PMVY
- Soyabean hsn code and gst rate
- ITR filing- non tax audit cases- Asstt.Year 2026-2027
- TAN for Partnership
- Last year TDS Claim
- CA IPCC Registeration in 2012, Is my registration Active or Expired
- TDS related Query_Liquidated Damages
- What is provisional receipt number for generation of form 16A
- NON- SUBMISSION OF LLP FORM 3
- Long Term Service award taxability in hands of company
- Form 27Q Correction statement taking too long to update on IT Portal
- ITR selection for salaries and capital gain less than L
- Showing Gift from relative in ITR for this year
- Gst invoice numbering and delivery challan numbering
- Standard Deduction claim for EPFO Pension and ICICI Prudential Life Annuity
- Small dealers gst returns filing
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
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
