| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#4
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cells Date (or any change) not working on imported data | Excel Discussion (Misc queries) | |||
| Imported data changes to date format (5-1-5 changes to May 1, 2005 | Excel Discussion (Misc queries) | |||
| How to format imported data | Excel Discussion (Misc queries) | |||
| unable to change date format on imported data | Excel Discussion (Misc queries) | |||
| Imported Data Date Format Problem | Excel Discussion (Misc queries) | |||
Linear Mode
