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 : 3338 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts