How to import numbers as numbers in excel?

[Your Display Name here...]

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.

 

[Gordon]

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?

 

[Gord Dibben]

If in one column only, I find the easiest method is to paste the data then
select and Data>Text to Columns>Next>Next>Column data format>General and Finish.

If in multiple columns Format all to General, copy an empty cell, select the
data and Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP