Problem in excel downloaded from GST portal
This query is : Open
CA Parul Saxena
(Querist)
04 December 2021
Tax comparison report downloaded from portal...but formula is not working there..#value error is there while calculating..
The reason is numbers there working as text...how to convert it to numbers...I have tried everything but does not working like...format cells,data text to column..
When i remove commas from numbers one by one then only formula is working..
Please suggest some other quick way to convert this text to numbers..
The reason is numbers there working as text...how to convert it to numbers...I have tried everything but does not working like...format cells,data text to column..
When i remove commas from numbers one by one then only formula is working..
Please suggest some other quick way to convert this text to numbers..
Ashiwini Ballodia
(Expert)
04 December 2021
try using paste special - as value
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
- EPF ECR NEW FILE SEP 17TH 2026
- Gst registered proprietorship firm
- SALARY CAN BE CAPITALIZE
- TAX AUDIT ON PROFESSIONAL INCOME
- Non filing of I T Returns
- TDS on purchase of under construction property from a reseller
- GST Intimation due to Government took possession of Business Premises under PPE Act
- Capitalgain tax purposes for valuation report compulsory
- TDS on Fixed Assets purchased
- SECTION 393(3) TAX ON CASH WITHDRAWAL
- Under marginal scheme
- Import of Software Service.
- Clarification Requested: Gift → NRO → NRE → Overseas Transfer - USA/CANDA (FEMA & Tax Compliance)
- GST on Renting godown to KFCSC for Storage of Raagi
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
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
