CSV Import Format Incorrect
John2312341324
Member Posts: 3
My bank uses words, rather than - or + symbols (in Dutch) to communicate if a transaction is a positive or negative one. How do I use Excel/Google Sheets to change it to the desired format? All imports are seen as additions.
Tagged:
0
Comments
Hey @John2312341324. I wasn't really able to find anything directly from searching on Google on how to adjust the Excel/Google Sheet to the desired format you are looking for -- however, my suggestion is potentially reaching out to one of the support team members at Google as they should be able to assist you with this particular situation.
John2312341324,
There are varying ways in excel to re-format your import file. For instance, using a true/false formula. Example: @if(b1=positive,-b1,0) What the formula is saying is, If cell b1 is the word positive then enter the negative value of b1, if not (false) then enter 0. Play around with it. Plenty of help on the net and samples.
Mike G, CPA