Easy Office
LCI Learning

Excel query

This query is : Resolved 
Profile Image

Profile Image

(Querist)
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
Profile Image

CA.Tarun Maheshwari

Profile Image

CA.Tarun Maheshwari (Expert)
01 June 2009 Yes. Put ' before entering the digits. i.e write your figure in this way -

'1564785641289652
Profile Image

CMA KNVV Sri Vidya - Sri Kanth

Profile Image

CMA KNVV Sri Vidya - Sri Kanth (Expert)
01 June 2009 Agree with Tarun sir
Upgrade to CAclubindia Pro. Subscribe Now!

Profile Image

Ankur Garg

Profile Image

Ankur Garg (Expert)
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

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries



Live Budget News and Updates

Trending Online Classes

view all classess
Let's Talk Money: You've Worked Hard for It, Now Make It Work for You
Click here for more bestsellers


Answer Query



Quick Links