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
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,334
Messages
5,571,589
Members
412,407
Latest member
ElmerCC
Top