Convert 16 digits from text to numbers

[JuliusV]

Hi,

I read online that if you have a 16 digit you want to display excel will automatically truncate the value to a 0 for the 16th digit onward.

Is there any way around this?

Also, will index match work if there is my search value is a number, but the value is in text form?

Thanks for the help!

 

[JuliusV]

For example
Index(Array with Numbers, match(4798130000170368, array))

4798130000170368 is in text form rather than number form.

Will index match recognize this?

 

[prasaddn]

For example
Index(Array with Numbers, match(4798130000170368, array))

4798130000170368 is in text form rather than number form.

Will index match recognize this?

why not you give a shot yourself?

 

[NARAYANK991]

Hi ,

If you can explain your requirement in more detail , a solution can possibly be thought of.

It is clear that Excel , without resorting to any add-in , can only deal with 15 digit numbers ; if you want to deal with 16 digit numbers , they have to be treated as text strings.

The question of whether text will match with numbers does not arise , since we are now discussing 16 digit entities , which cannot be numbers , whether in the array or as the lookup value. If you need to maintain your data as 16 digit entities , they have to be text strings everywhere.

Please explain what your real requirement is , and it may be possible to suggest an appropriate solution.

Narayan

 

[Istiyak]

Use helper column with formula.

Left(Cell NO of 16digit card,16)

now you can perform your task with this helper column

have look on sample upload