Thx.
Further to this, wanted to check as to how can i check any duplicates on the
text field - In case there is any no. getting repeated more than once...

Rgds/ /sk.

"Ashish Mathur" wrote:

Hi,

Format the cells are text values and then input the numbers in those cells.
In this application, one can one enter number upto 15 digits.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sansk_23" wrote in message
...
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.