When I try to run my pivot table the column with Amounts has either leading or trailing spaces and when I try to use TRIM it doesn't correct the problem. If I type in the numeric
it works. I've also tried clean but it doesn't work either. I have lots of rows of amounts and it will take forever to type in the numeric s. Any suggestions
it works. I've also tried clean but it doesn't work either. I have lots of rows of amounts and it will take forever to type in the numeric s. Any suggestions