12-01-2016, 11:24 AM
Yeah so more or less advanced but I struggle with this.
So I get the value of either something like "37.5K" or "134K".
And I want it to look like a normal number, so 37500 or 134000.
The problem is I cant just replace the "K" with "000" because then the
"37.5K" would look like 375000 which is too much.
So I would need something like:
[if there is a "." in the Name then replace "K" with "00", if not replace with "000"]
Is there a way to that in Quick Macros?
So I get the value of either something like "37.5K" or "134K".
And I want it to look like a normal number, so 37500 or 134000.
The problem is I cant just replace the "K" with "000" because then the
"37.5K" would look like 375000 which is too much.
So I would need something like:
[if there is a "." in the Name then replace "K" with "00", if not replace with "000"]
Is there a way to that in Quick Macros?