Goal: I need to send an excel file to a txt file for a testing procedure.
My first issue I need to resolve is the decimal is showing in my text file. Some of the figures in my excel spreadsheet have decimals. The catch to this is some of them can only be dollar amounts (even though there might be cents) and some can have both - no rounding and no decimal allowed in txt file.
If someone can provide me with what will be helpful for me to attach to this I will.