If the data you brought into Excel comes through as text rather than numbers, Paste Special can fix it.
- Go to an empty cell.
- Copy it
- Select the "corrupted" data.
- Go to Edit>Paste Special and choose Add.
What's So Special About "Paste Special"?
Excel Paste Special function
Pasting Using Paste Special
See all Topics