View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Your Display Name here... Your Display Name here... is offline
external usenet poster
 
Posts: 4
Default 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.