Text fields are treated as numbers when opening CSV file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dsadsadasdsa - 21 Mar 2008 21:28 GMT

I have cell in CSV file that has string 03073E105 in it (this is CUSIP).

When I open it in Excel it looks like 3.073E+108

I understand what happens and why but this is not what I want.

Is there a way to achieve every cell to be treated as text?

Reply to this Message

Dave Peterson - 21 Mar 2008 21:49 GMT

I'd rename the .csv file to .txt

Then when I did file|Open, I'd be prompted for each field type.

You could also try using Data|Import external data|Import data, too.

> I have cell in CSV file that has string 03073E105 in it (this is CUSIP).
>
[quoted text clipped - 3 lines]
>
> Is there a way to achieve every cell to be treated as text?

Signature

Dave Peterson

Reply to this Message

timmg - 24 Mar 2008 17:22 GMT

On Mar 21, 3:28 pm, "dsadsadasdsa" <dasd...@ddddddddd233232.com>
wrote:

> I have cell in CSV file that has string 03073E105 in it (this is CUSIP).
>
[quoted text clipped - 3 lines]
>
> Is there a way to achieve every cell to be treated as text?

You can format the cell to number (it defaults to general) to just
show the number. If you want to display leading zeros make a custom
format of 000000... with 1 zero for each place.

select the cell(s) and got to format/cell and click on the number tab.

Reply to this Message

Rate this thread: