Convert exponent from string to number

[PavolBuck]

Hello everyone,

i need little help. In my process i got from Excel exponent save in data type Text. For example 3,60887497663498E-09. How I can convert it to number?

Thanks

------------------------------
Pavol Buck
------------------------------

[michaeloneil]

Hi @PavolBuck

I think you're asking to convert the data type to number before you get it from the excel? If you want to do that use the MS Excel VBO and the action Format Cell and set the format to "0.00" you can set this for an individual cell by providing the cell address or the entire column e.g. B6 or B:B

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

[rsrivastava2]

Hi Pavol,

The problem here is not the VBO or Blue Prism but MS Excel and solution is by converting NUMBER to TEXT.

If you cross some set number of digits, in my case 16 (card number) digits, the number is represented in this format.

Simple tweak is to convert the number to text, you can do this either by - 

1. Converting the column to text, if you can control that.
2. Send value enclosed in quotation marks, some even suggest adding a single quote before the number.

Do let me know how this work out for you.

Hope this helps.  

------------------------------
WeitghtRPAMatey
------------------------------