Exporting from Business Objects into Excel | Excel forum

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