How to import numbers as numbers in excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Your Display Name here... - 06 Jul 2007 15:44 GMT

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 to this Message

Gordon - 06 Jul 2007 15:53 GMT

>I have a column of numbers with 2 decimal places (monetary amounts). If
>copy
[quoted text clipped - 9 lines]
>
> Any help appreciated.

Where are you copying these numbers from?

Reply to this Message

Gord Dibben - 07 Jul 2007 00:34 GMT

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

>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
[quoted text clipped - 7 lines]
>
>Any help appreciated.

Reply to this Message

Rate this thread: