How to import numbers as numbers in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Your Display Name here... said:
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.
Click to expand...


Where are you copying these numbers from?
 
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
 
Back
Top