How to import numbers as numbers in excel?
 

I have a column of numbers with 2 decimal places (monetary amounts). If copy
and paste into excel, it converts them to text. If I import the text as a
text file, excel converts it to text. If I open the text file (which has a
column of numbers and nothing else), excel converts them to text.

I can verify that excel changes the default format because autosum adds up
the column of numbers as "$0.00".

I was trying to sum up a bill.

Any help appreciated.

How to import numbers as numbers in excel?
 

"Your Display Name here..."
wrote in message ...
I have a column of numbers with 2 decimal places (monetary amounts). If
copy
and paste into excel, it converts them to text. If I import the text as a
text file, excel converts it to text. If I open the text file (which has
a
column of numbers and nothing else), excel converts them to text.

I can verify that excel changes the default format because autosum adds up
the column of numbers as "$0.00".

I was trying to sum up a bill.

Any help appreciated.



Where are you copying these numbers from?

How to import numbers as numbers in excel?
 

If in one column only, I find the easiest method is to paste the data then
select and DataText to ColumnsNextNextColumn data formatGeneral and Finish.

If in multiple columns Format all to General, copy an empty cell, select the
data and Paste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Fri, 6 Jul 2007 07:44:04 -0700, Your Display Name here...
wrote:

I have a column of numbers with 2 decimal places (monetary amounts). If copy
and paste into excel, it converts them to text. If I import the text as a
text file, excel converts it to text. If I open the text file (which has a
column of numbers and nothing else), excel converts them to text.

I can verify that excel changes the default format because autosum adds up
the column of numbers as "$0.00".

I was trying to sum up a bill.

Any help appreciated.