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
- About TDS & Income Tax
- Pass word to open justification report for Q1 for FY 2026-27
- PPF interest-As Exempt Income disclosure
- Section 194JA & JB Income which ITR Form to use
- Scrutiny and reopening of past returns
- Type of Capital Gain
- F & O PROFIT REPORTING FOR AY 2026-27
- Booth for sales promotion
- Difference in GSTR3B system generated which is correct and actual Payment it asks
- GST ON TRAVELLING BILLS
- TDS on Rent received on redevelopment of building
- Tax on Deemed Capital Gain
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Taxation in the hands of Landowner under JDA
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
