Cell Format on Imported Data

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....
 
M

Mike H

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
 
A

Al

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

S. Kissing

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell not calculating after importing data 2
Convert $ to actual numbers in an imported web query 1
Format number 2
Formatting Imported Data 1
$ in Excel cells won't appear 3
Cell requires double click to 'activate' date format change 3
Formatting with imported data 2
unable to change date format on imported data 1

Top