Hi,
I use an app which works out Average Item Price. When I export from the app
to excel, I'm expecting to see £6.33, but instead I get '6.33125634544 . The
' seems to mark it as text, so neither the currency button or format as
currency works. Find and replace won't find the ' .

This should be simple but I'm really stuck. The volume of work means
manually changing each cell really isn't an option.

Help !

Rich