Cannot do calculations with numbers?

G

GreenInIowa

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.
 
D

daddylonglegs

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 Edi
 
Top