Excel query
This query is : Resolved
01 June 2009
i want to add a 16 digit number in excel, but last digit automatically turns into "0". Say if i enter 1564785641289652 than last digit "2" will automatically turns into "0"
any body has any solution for this?
Eagerly waiting for solution
CS. Jatin Vora
+91 9898864690
any body has any solution for this?
Eagerly waiting for solution
CS. Jatin Vora
+91 9898864690
01 June 2009
Yes. Put ' before entering the digits. i.e write your figure in this way -
'1564785641289652
'1564785641289652
01 June 2009
Agree with Tarun sir
03 June 2009
Perfect answer.
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
