//sk - Max length of a numeric field.

[sansk_23]

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.

 

[Ms-Exl-Learner]

Just format the cell as Text and try to enter the value

Select the range and do Right Click and select Format
Cells>>Number>>Category>>Text and give ok.

Otherwise before entering the value in a cell type ' and enter your Zero
value numbers.

If this post helps, Click Yes!

 

[Ashish Mathur]

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]

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.

 

[Ms-Exl-Learner]

Try this function…

=COUNTIF(A:A,A1)

Here I have mentioned the range as A:A change it to your desired Column.
Assume that if your data is present in column D then change it to D and in
the same way change the criteria A1 to your desired cell. In this example it
should be marked as D1.

After applying this function just copy and paste it to the remaining cells.

If this post helps, Click Yes…