# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Numeric format

Hi!

I have an excel file as a data source and I need to import a 17-digit numerical field into Qlik Sense, but in doing so, the import is done by displaying the number according to the scientific notation

How can I do to see the 17 digits?

1 Solution

Accepted Solutions
Contributor

## Re: Numeric format

Hi,

Div(IDAccount, '1e10') & left(repeat('0',10), 10 - len(text(Mod(IDAccount, '1e10')))) & Mod(IDAccount, '1e10') as Account,

and it worked

First of all, I had to chage cell format in excell from numeric to general

Thanks!

7 Replies
MVP

Contributor

## Re: Numeric format

Thanks Sunny!

Honored Contributor II

## Re: Numeric format

As its an identifier field could you split it using left and right functions along logical identification lines.

Looks like the first 12 digits are used.

Valued Contributor

## Re: Numeric format

Div(IDAccount, '1e10') & left(repeat('0',10), 10 - len(text(Mod(IDAccount, '1e10')))) & Mod(IDAccount, '1e10') as IDAccount,

Contributor

## Re: Numeric format

Hi,

Div(IDAccount, '1e10') & left(repeat('0',10), 10 - len(text(Mod(IDAccount, '1e10')))) & Mod(IDAccount, '1e10') as Account,

and it worked

First of all, I had to chage cell format in excell from numeric to general

Thanks!

Valued Contributor

## Re: Numeric format

Thank you for sharing That yes it was changing the last two digits as it is remainder of the number.

Glad you were able to fix it.

Contributor

## Re: Numeric format

HI again,

I´m working in another project with codes and I applied the @Jahanzeb Hashmi solution to managed the same problem, but it didn´t work this time: some codes match with the ones in excel (column C, green codes) and some don´t (column C, red codes).

Any idea to solve this problem?