 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Cell 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.... 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 > 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.... 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. > 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.... Not vb.net, using SQL. > Are you programming in vb.net? > [quoted text clipped - 6 lines] > > format and enter. This is impossible as there are thousands of numbers to > > change. HELP.... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.