| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import complex numbers to excel | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Import scanned numbers into excel | Excel Discussion (Misc queries) | |||
| Excel: How to import numbers from one spreadsheet onto another. | Excel Worksheet Functions | |||
Linear Mode
