I am using the Parse Excel Spreadsheet to CDT smart service and have a list of n

Howard over 10 years ago

I am using the Parse Excel Spreadsheet to CDT smart service and have a list of numbers that are being saved into a text field. It is doing the conversion fine on most of the numbers, but some of them are put into this format, 1.006473e+07. I checked the Excel formatting and it is set to Text. Is there a way to convert this number back into it's original value, 10064729? I am using Appian v7.3. Thanks....

Discussion posts and replies are publicly visible

0 Aleksi White
Appian Employee
over 10 years ago

This is the way that Excel formats text by default. If you right click on the cell(s), go to Format Cells, then you'll see a box pop up with a list of cell formats. Choose 'Number' to prevent excel from using scientific notation, and write out the entire number.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rogerp63
Certified Senior Developer
over 10 years ago

fixed(todecimal(ri!string),0,true)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel