Excel : Write Range: Converting a number to another format

Learn Academy Feedback
#1

Iam using Excel Application scope to write the value “201810009198” to a cell.
Bu the value written to excel is “2.0181E+11”

But when we click on that particular cell, the value can be seen as “201810009198”.

Can someone help me to fix this issue.

Thanks in advance
Maria Josephina

#2

Hi @maria.josephina
well the representation that you have in the excel is due to how excel tend to show big numbers by default.
To have the normal representation try and

  • right click on the excel column (or cell)

  • Choose format cells

  • under Number choose the category Number
    image

if you want an integer representation you can press down the Decimal places to 0 and click ok

hope it helps solve the problem

2 Likes
#3

Thankyou for the information.
But It will write the correct value “201810009198” when we are using Write Range activity of workbook.

1 Like