Excel Paste Special Values Only

0
votes

I am bringing in a column of data from an external spreadsheet into one I developed. Mine has very specific formats applied to ensure formulas work. One of the columns requires data to be formatted as 'Number'.

The source spreadsheet has a column with both 'Number' formatted cells and 'Number stored as text' cells.

When I copy this column and use 'Paste Special - Values Only' I get the same cells with 'Number stored as text'.

I thought that the 'Paste Special - Values Only' was meant to prevent this kind of issue.

Can someone shed any light on this?

1
excelcopy-pastepasteexcel-2016

1 Answers

0
votes
  1. arrange yourself a service column and fromat it as "General"
  2. then insert a formulas into this service column like this =value(A1) where A1 is the location of a number which is stored as text
  3. copy the service colunm into the A column (which is where the number is located as text)

the problem should be solved then