//sk - Max length of a numeric field.
Just format the cell as Text and try to enter the value
Select the range and do Right Click and select Format
CellsNumberCategoryText and give ok.
Otherwise before entering the value in a cell type ' and enter your Zero
value numbers.
If this post helps, Click Yes!
--------------------
(MS-Exl-Learner)
--------------------
"sansk_23" wrote:
Hi !!
Want to have a series of numbers - 19 digits long.
like - 8999876456789650000
The issue is that am unable to mention any no. for the last four digits.
It always takes it as 0000 .
Why am i unable to change this and is there any way that i can mention any
other no. that 0000. ?
Rgds //sk.
|