98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Exporting from Business Objects into Excel | Excel forum
Exporting from Business Objects into Excel | Excel forum
Resolved · Low Priority · Version Standard
Jiwan has attended:
Access Introduction course
Exporting from Business Objects into Excel
Exporting data from Business Objects (query run on Oracle DB) into excel, the data which is in number format in BO sometimes appears in Excel as text. How can the format of that be changed to 'number' such that it can be calculated upon?
Value function - converting text to Numbers
Dear Jiwan
Thank you for attending Access Intro. I hope that you enjoyed the course and benefited from it.
I'd like you to try the Value function.
Simply insert a new column next to the column where the values appear as text.
Type =Value(Text) where Text will be the cell that contains the number that appears as text.
Replicate (Copy and paste) the cells to the other cells so that function is pasted to other cells in that column.
Select all the cells with the Value functions and then Choose Edit > Copy.
Without deselecting the cells choose Edit > Paste Special... and then choose Values.
Press OK
Delete the original column with the values that contained Text.
This should be able to resolve your query.
If it doesn't work then please press the reply button and I should be able to research into it!!
If this has helped in resolving your query then I would request you to mark this post as Resolved.
Thank you
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Outlining - ungrouping rows or columnsHighlight want you want to ungroup and press ALT + SHIFT + right cursor arrow |