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
- STCG....................................................
- Supply through E-commerce Operators
- TAN for Partnership
- Sales return eway bill
- Relief u/s Section 89
- AMOUNT RECEIVED UNDER COMPULOSRY ACQUISITION OF AGRICULTURAL LAND
- Is E Way Bill Valid If Transport ID Not Mentioned in PART A But Vehicle details mentioned in PART B
- STCG on ETF gold & silver
- If there is Long term capital gain exists how much total income to be considered
- GST Rate applicable for 0% Food Items sold by an Industrial Caterer
- Section 54F - Exemption on LTCG in 2026 for HP purchased in 2023
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- Nomination of Bank for refund in itr 2
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
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
