Cannot do calculations with numbers?
 

Hi,

Sometimes I get numbers from others to Excel, but when I try to make simple
calculations I cannot. I though the problem is about formatting of the
numbers. Apparently, this is not the case since even if I re-format it as
number the problem persists. I was wondering why?

Thanks.

Cannot do calculations with numbers?
 

Unfortunately if your "numbers" are, in fact, text then "re-formatting"
as numbers doesn't work. Test by using this formula in another cell

=ISNUMBER(A1). If you get FALSE you need to convert

...to convert to numbers.

For one column...

select column. Use Data Text to Columns Finish

for a range.

put a 1 in an unused cell, copy that cell, select your range. Use Edit
Paste special multiply OK


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528336

Cannot do calculations with numbers?
 

Thank you very much, daddylonglegs!

GreenInIowa



"daddylonglegs" wrote:


Unfortunately if your "numbers" are, in fact, text then "re-formatting"
as numbers doesn't work. Test by using this formula in another cell

=ISNUMBER(A1). If you get FALSE you need to convert

...to convert to numbers.

For one column...

select column. Use Data Text to Columns Finish

for a range.

put a 1 in an unused cell, copy that cell, select your range. Use Edit
Paste special multiply OK


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528336