I currently have a txt file which is pulling through our values as follows:
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
@BronKroon Try this
Format the result as currency.
Inge - you're a legend. Thanks so much