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
- GSTR-1A How to update Invoice
- Excess salary payment.
- Capital gain from sale of house property
- TDS on Purchase of Immovable Property by NRI from NRI
- Stamp Paper for partnership firm change new income tax 2025
- Current Account Opening for Sole Proprietorship with Udyam Certificate - Zero Turnover
- Value of property in capital gain
- Regarding TDS Applicability For Director Remuneration
- FORM 26A APPLICABILITY
- SFT Cash Deposit in Current Account
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
- Address Change to another state of a Registered Trust with 12AB approval
- Updated return in budget 2026
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
