Looking to remove the decimal point from numbers in a column without rounding. (e.g $100.50 should become 10050)
Anyone know if this is possible / how to accomplish?
Multiply by 100?
That works but it introduces a comma so it reads 10,050 when it should be 10050.
If you change units to none in data formatting the commas will go away
Awesome. Thank you both.