Rich

Format cells to General.......won't change to numbers yet.

Copy an empty cell formatted to General.

Select range of numbers and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Sat, 10 Dec 2005 16:20:04 +0000 (UTC), "Rich" wrote:

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