98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Importing Numbers in Excel 2010

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

Added by Yolande on 27th September 2011

More Excel hints and tips, like:

• Changing Excel file and worksheet defaults
• Autofit column width – Excel (all versions)
• Remove unused toolbar buttons