When changing numer to text, it puts comma and decimal, for eg
var = 1234
"aa" + CSTR(var)
would give: aa1,234.0
to get rid of , and . use following syntax
TOTEXT({variable}, 0, "")
Arguments: Variable is the one you are trying to convert into text
0: number of decimal places you want
"": thousand separator (here its nothing)
astu...
No comments:
Post a Comment