How do I remove the extra spaces so the numbers match when I run the pivot table. The total should be 4 instead of 2, since the numbers are the same.
Is there an easier way to do this beside going in front of the number and deleting the extra space.
I tried using the paint brush to match properties but it didn't work
Last edited by Jerseynjphillypa; 11-08-2011 at 12:44 PM.
Select the numbers and then choose Text To Columns and click Finish.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Use the Text to columns option in the same column - its available in the Data menu. Once you use that, it will convert the text to numbers. And you will have the right numbers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks