|
Posted to microsoft.public.excel.misc
|
|
|
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....
|