allow to enter more than 15 digits in excel cell of MSoffice 2010

Posted by Santosh4u under ASP.NET on 11/12/2012 | Points: 10 | Views : 2202 | Status : [Member] | Replies : 1
Hi

is it possible to allow more than 15 digits in a Cell of MS Excel 2010.

my grid column values contains 16 digits number in a grid and after exporting data to a excel from grid,the 16th position of the number is coming as "0".

i,e if the number is "2312345678445008" in grid cell and after exporting into excel this value is showing in excel as "2312345678445000".


How can i rectify this issue.

Thanks




Responses

Posted by: Krv on: 11/15/2012 [Member] Starter | Points: 25

Up
0
Down
Making cell as 'Text' allows 2312345678445008 value.

Thanks,
R.Vasanth
MCTS(SQL Server & BI)
http://bigdatatech.blogspot.com

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response