Change Text number entry to Currency format

[TomHead]

Hi All,

My problem is finding the right function or macro formula to change items that I have imported from historical sports results information.

The data imported has winnings typed in as text including the dollar sign and comma. What I need to do, is convert those entries to format as Currency and be able to add the column totals.

The 2nd thing i need to do, is to remove the T in front of the numbers of finish position, when the players finish in a tie... I need this so a sort according to finish position will appear correctly.

I will attach sample of what I import:

Hope I explained this right and posted properly..
Thanks for help in advance.

Tom

[sweep]

Hi,

To give value of earnings, =VALUE(MID(I2,2,LEN(I2)-2))

To give position minus the "T", =SUBSTITUTE(A2,"T","")

[TomHead]

Dave,

Had to work on my insertion skills... but figured it out eventually.

Thanks very much.... That took care of the problem and will save me many hours...

Again, Many Thanks

Tom