Forum Discussion
copy paste special values with using VBA
I see you can use VBA to copy the value of a formal. For those who don't know VBA can you do this using a formula. My goal is to use a worksheet template that when I insert a column of data into a ce...
excelnewbie1 Alternatively, use Text-to-columns on the Data ribbon.
1: Select the column with the amounts in a text format;
2: Data, Text-to-columns;
3: Step 1 of 3, choose Delimited, press next;
4: Step 2 of 3, in the preview window, select the first column and check the "Do not import column (skip)" button. Then select the 2nd column, check the "General" button and press "Advanced...". Make sure that the comma is set as the thousand-separator. Press OK, Press Finish.
You should end up with one column of numbers. No formulae or VBA needed.