Vb 6.0 and Crystal Report 8

Hello,
I am having a problem in displaying the currency symbol when I export a report to Excel format (excel 8.0 extended). On the report it is displaying £ sign which is what I want. But when I export it to excel, is is showing $ sign.I want the excel also to display the £ sign.Any idea about it...
Thx

You should create a new thread with a new title for a new problem... It would get more attention that way.

Posts split. :)

How have you added the £ currency sign? Excel shows it as $ besed upon the users locale. ;)

Change ur currency symbole setting in MS Excel