How to put 19 digit or more digit number in a excel cell.
I want to save 19 digit number in cell of column .How I will format that cell.Can anybody give me some idea in this regard?
feedback
|
migrated from stackoverflow.com Feb 4 '10 at 18:28
This question came from our site for professional and enthusiast programmers.
|
You can always store the number in the cell as a string. Put an apostrophe in front of the number. | |||
|
feedback
|
|
If you change the format of the cell to 'Text', you don't need to prepend an apostrophe; you just put in the number. It will still even be usable as a number by functions that refer to the cell. | |||
|
feedback
|
|
Excel seems to allow only 15 digits. What on Earth are you doing that really requires 19 digits of precision? I suspect you're either not stating your problem well or you're worry about unnecessary details. | |||
|
feedback
|
