 |
 | 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 / New Users / April 2007Formatting Numbers
When I export data to excel it doesnt recognise the numbers as numbers. Even when I format the row to numbers it doesn't recognise them. I have to retype then in order for me to do calculations. Any help greatly appreciated. How are you exporting the data to Excel, and from where? Formatting does not change the value in a cell. In particular, it cannot change text to a number--it merely prepares the cell to accept a number. One possible workaround is to copy a blank cell, then select the range of imported data and Edit|Paste Special|Add. Adding zero to each cell should coerce their contents to numbers if it is possible to do so. Jerry > When I export data to excel it doesnt recognise the numbers as numbers. Even > when I format the row to numbers it doesn't recognise them. I have to retype > then in order for me to do calculations. Any help greatly appreciated. Thank you, that worked perfect. I am exporting from a database that was designed for our use, think designed in Oracle though I can say for certain not being a whiz kid at these kind of things. Thanks again for your help. > How are you exporting the data to Excel, and from where? > [quoted text clipped - 10 lines] > > when I format the row to numbers it doesn't recognise them. I have to retype > > then in order for me to do calculations. Any help greatly appreciated. The way that Oracle is writing the file, causes Excel to interpret the data as text. Your programmers may be able to revise the output file so that Excel will interpret it as numbers. Otherwise continue to use this work-around. Jerry > Thank you, that worked perfect. > [quoted text clipped - 17 lines] > > > when I format the row to numbers it doesn't recognise them. I have to retype > > > then in order for me to do calculations. Any help greatly appreciated.
|
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.