S
scottrichards7
I have a column of numbers that look like $2.000, $22.000, $222.000 or
$2,222.000. The problem is they have a leading space (before the $)
and lagging space (after the third 0).
I've tried text to columns, =trim, =clean and copy/past special/values
or addition or multiple with no luck!
I just need to convert them text to numbers - HELP! Solutions are much
appreciated.
$2,222.000. The problem is they have a leading space (before the $)
and lagging space (after the third 0).
I've tried text to columns, =trim, =clean and copy/past special/values
or addition or multiple with no luck!
I just need to convert them text to numbers - HELP! Solutions are much
appreciated.