Excel.range("").Value - Going wrong Topic is solved

Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
brunopare
Posts: 11
Joined: 15 Jun 2021, 13:37

Excel.range("").Value - Going wrong

Post by brunopare » 01 Jul 2021, 09:23

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
variable.png (2.96 KiB) Viewed 281 times
Send.png
Send.png (1.36 KiB) Viewed 281 times

brunopare
Posts: 11
Joined: 15 Jun 2021, 13:37

Re: Excel.range("").Value - Going wrong

Post by brunopare » 01 Jul 2021, 09:55

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:

User avatar
mikeyww
Posts: 27372
Joined: 09 Sep 2014, 18:38

Re: Excel.range("").Value - Going wrong  Topic is solved

Post by mikeyww » 01 Jul 2021, 10:03

If you want to round the number, you could try adding Round.

Post Reply

Return to “Ask for Help (v1)”