Numbers getting converted to exponential

Hi All, 

I am using Excel to CDT smart service, and in my excel, one of column lets say Column A contain numbers, format in Excel is Text Only. I am storing this number as Text Datatype in Appian. 

Issue is Column A values which is actually number in Excel and mapped to Text datatype in Appian is getting converted to Exponential. I tired using Fixed(), todecimal() and text() function but non of this giving me required output. 

Another strange behavior we noticed is, Converting Excel cell to Text worked fine in Development and Test environment but same thing is not working in production. 

I checked few of existing post on same issue but didn't find satisfactory answer.

E.g :

Excel cell value : 9122604701,

Appian Converting it to : 9.122605e+09,

Required output as : 9122604701

Regards,

Simple Shah

  Discussion posts and replies are publicly visible

Parents
  • 1)Try to check whether your Excel filed is in text format or not(Check the formatting of excel for all value that is being given in the file)
    2) Try to check the CDT filed (try to receive it in text format)
    I have tried to upload a file with the number given by you and it is working fine for me.

    It also should work for you.
    Regards,
    Neha Dangi
Reply
  • 1)Try to check whether your Excel filed is in text format or not(Check the formatting of excel for all value that is being given in the file)
    2) Try to check the CDT filed (try to receive it in text format)
    I have tried to upload a file with the number given by you and it is working fine for me.

    It also should work for you.
    Regards,
    Neha Dangi
Children
No Data