Cell Format on Imported Data

  • Thread starter Thread starter S. Kissing
  • Start date Start date
S

S. Kissing

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....
 
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
 
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.
 
Not vb.net, using SQL.

Al said:
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.
Click to expand...
 
Back
Top