Excel.range("").Value - Going wrong Topic is solved
Excel.range("").Value - Going wrong
Hey guys, i'm having a little problem with .value function. On Excel i have the number 14 , but when i get this value using Excel.Range("A"control_row).Value, and send he returned 14,000. How i can get just the 14 number without the ",000" ?
- Attachments
-
- variable.png (2.96 KiB) Viewed 280 times
-
- Send.png (1.36 KiB) Viewed 280 times
Re: Excel.range("").Value - Going wrong
Guy i got it, using the .Text i can get the real Value. Ex: Excel.Range("A" linhacontrole).Text.
But feel free to give me tips on how to deal with these situations![Thumbup :thumbup:](./images/smilies/icon_thumbup.gif)
But feel free to give me tips on how to deal with these situations
![Thumbup :thumbup:](./images/smilies/icon_thumbup.gif)
Re: Excel.range("").Value - Going wrong Topic is solved
If you want to round the number, you could try adding Round.