anyone know how to change the
9.06002E+15 here like this 906C0017110254992
9.06002E+15 this happens when i have id that contains so many 0(9060020000000000)
im using ah .csv file. i tried to edit the format but when i save, close and open the file it always come back in this format 9.06002E+15
i can’t match few id’s because of this issue. please help.
Check out this XAML file in the thread
If you use ExcelWriteRange or WriteRangeX, can you try to use Workbook-WriteRange as the following?
i need to read the csv file and match id from other excel file . my problem is, i can’t match few id’s cause the id format is changed by excel to 9.06002E+15.
Have you tried with Format cell activity
Check out this thread
How about this expression?
Note : dd-MM-yyyy -> Based on excel date fomat
You can try to change the format of the column
Excel process scope activity
Use excel file activity
Format cell activity
we are using old version.
Can you tell us how the data will comes into CSV file?
How did you input these data into the sheet?
Current data is not very good because it might be drop accuracy. For example, can you try to input the following 2 values?
Both will be “9060020000000000” due to digit accuracy.
So it might be necessary to review way to write data.