| Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Run-Time Error '13' Type Mismatch > Copying and Pasting Data | Share |
Copying and Pasting Data
Excel Help for Copying And Pasting Data in Excel Multiple Regression Analysis and Forecasting Template
| Forum Topic | Login |
Copying And Pasting Data | Rate this: (3/5 from 1 vote) |
 | The type mismatch error is normally due to copied data being formatted as text rather than numbers. This can happen for a number of reasons; however there are some solutions. The simplest solution is to do a find and replace (CTRL+H) on apostrophies (i.e. ') for nothing. Otherwise one can import data using the Data >> Import External Data function from the Excel menu to ensure that values arte imported in numeric format. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Copying and Pasting Data in the Excel Business Solutions Directory |