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?

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