Problem in excel downloaded from GST portal
This query is : Open
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..
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
- Is this income indian or foreign income?
- GST on export of services and Input Credit
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- ITC temporary reversal and reclaim
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- GST ON EXPORT COMMISSION
- Should I report my US salary for January, February, March in Schedule FA?
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Tds on building rent monthly
- Regarding Waiver of Interest levied u/s 50 of PGST/CGST Act
- Confusion around Form 26QB fields
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- 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
CAclubindia
