Convert numbers to dollar value in excel

[BronKroon]

I currently have a txt file which is pulling through our values as follows: 

000000000000012730C

000000000002403840D

How do I convert this to a dollar value where all C items are negative and D are positive., and the last 3 digits of the number are after the . 

i.e. the above should read -$12.73 and $2403.84

Regards

Bron Kroon

[#2]

@BronKroon  Try this

=LEFT(A1,18)/1000*IF(RIGHT(A1,1)="D",1,-1)

Format the result as currency.

[#3]

Inge - you're a legend. Thanks so much