Cell Format on Imported Data
 

I have imported data from Oracle (using programing, not import). This is a
large file and it brought all numbers over as text. When I choose the column
and fomat as number nothing happens. I have to choose each cell change
format and enter. This is impossible as there are thousands of numbers to
change. HELP....

Cell Format on Imported Data
 

One way that can work is to put a 1 in a cell and copy it, then select your
text numbers and

Edit|Paste Special
Select multiply and click OK
Delete the 1

Mike
"S. Kissing" wrote:

I have imported data from Oracle (using programing, not import). This is a
large file and it brought all numbers over as text. When I choose the column
and fomat as number nothing happens. I have to choose each cell change
format and enter. This is impossible as there are thousands of numbers to
change. HELP....

Cell Format on Imported Data
 

Are you programming in vb.net?

If you are then set the input datatype is 'Double' and it will import with
the format of a number rather than text.

"S. Kissing" wrote:

I have imported data from Oracle (using programing, not import). This is a
large file and it brought all numbers over as text. When I choose the column
and fomat as number nothing happens. I have to choose each cell change
format and enter. This is impossible as there are thousands of numbers to
change. HELP....

Cell Format on Imported Data
 

Not vb.net, using SQL.

"Al" wrote:

Are you programming in vb.net?

If you are then set the input datatype is 'Double' and it will import with
the format of a number rather than text.

"S. Kissing" wrote:

I have imported data from Oracle (using programing, not import). This is a
large file and it brought all numbers over as text. When I choose the column
and fomat as number nothing happens. I have to choose each cell change
format and enter. This is impossible as there are thousands of numbers to
change. HELP....