Hi
Excel allows entry upto 15 digits there should not be any problem with
entering 296100210001856
You mat add ' before number if you want to store digits more than 15.
Cheers!!
ᐧ
On Fri, Jan 30, 2015 at 3:48 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
I checked it in version of
Change cell format to number with zero decimal places..
ᐧ
On Fri, Jan 30, 2015 at 2:43 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear experts,
I enter number 296100210001856 in cell of excel in number format but after
given enter the number change to 296100210001850.
I checked all
what is your MS office version?
ᐧ
On Fri, Jan 30, 2015 at 3:24 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
I did it same also but though problem remaining same.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary.
Spread
Dear experts,
I enter number 296100210001856 in cell of excel in number format but after
given enter the number change to 296100210001850.
I checked all the way but not found any solution, pls check n reply for
solution.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless
I checked it in version of 2007 2003.
And also checked same sheet by opening in another PCs and also by creating
new sheet.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Fri, Jan 30, 2015 at 3:36
Yes, I doing same, but is there any solution to type in number format more
than 15 digit?
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Fri, Jan 30, 2015 at 3:50 PM, Vaibhav Joshi v...@vabs.in
Hi Bhalara,
Select the cell
Go to in Format Cell
Click on Text
Enter
Now, type your No.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
There's an addin called Xnumbers which performs multi-precision floating
point arithmetic from 1 up to 250 significant digits.
You can download it from here:
http://www.thetropicalevents.com/Xnumbers60.htm
Cheers!!
ᐧ
On Fri, Jan 30, 2015 at 4:00 PM, Ashish Bhalara ashishbhalar...@gmail.com