Numbers Copy and Paste Format Trouble

cultgag

New Member
Joined
Dec 2, 2005
Messages
4
TIA

I copy a forecast from a website and paste the numbers in excel for calculations. But it won't let me modify those numbers for some reason. They must be recognized as a text, i'm not quite sure. I need to be able to get excel to recognize these numbers as numbers.

I'd appreciate all the help. :biggrin:

-Matt
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

kjo1080

Active Member
Joined
Aug 2, 2004
Messages
325
Try entering the number 1 in any open cell . . . select that cell, copy it, then select all the numbers you are trying to convert from text to numbers, and paste special > multiply.

Hope that helps,

KJO1080
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,057
Messages
5,835,162
Members
430,343
Latest member
t0m_c

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top