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

Parents

0 rogerp63
Certified Senior Developer
over 9 years ago

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

Sign in to reply

Verify Answer

Cancel

Reply

0 rogerp63
Certified Senior Developer
over 9 years ago

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

Sign in to reply

Verify Answer

Cancel

Children

No Data