Code: Select all
[code]
oldCount = 1,234,000
newCount = 1234500
change := newCount - oldCount ; empty
Code: Select all
[code]
oldCount = 1,234,000
newCount = 1234500
change := newCount - oldCount ; empty
Code: Select all
var := "1,234,000" ; Note the non-digit characters (',')
MsgBox % var + 0
var := "1234000"
MsgBox % var + 0
Code: Select all
q::
oldCount = 1,234,000
newCount = 1234500
oldCount := StrReplace(oldCount, ",")
MsgBox, % change := newCount - oldCount
return
w::
oldCount = 1,234,000
newCount = 1234500
MsgBox, % change := newCount - StrReplace(oldCount, ",")
return
Nice one, this made me realise that the google sheets api I used defaults to formatted values, I changed it to unformatted and I don't need to convert it in ahk anymore.jeeswg wrote:Could be good: