Hi Bryan,

It works!!!

I discovered my problem. Thread #5 contains:

Bryan Hessey Wrote:

try

=IF(MID(A1,2,1)="$",LEFT(A1,1)&TEXT(MID(A1,3,FIND( "
",A1)-3)/3,"$#.00")&MID(A1,FIND(" ",A1),99),A1)

When I copied that formula, I inadvertantly included the on the
second line so, when I pasted it into my spreadsheet, that section of
the formula looked like this:

FIND(" ",A1)-3)/3e

Deleting the resolved my problem.


Thank you muchly for you help!

gary