Home → Problems →

Exporting Data to Excel

• Edit

tcuffe

Nov 12, 2013 @ 04:41 AM

I have been using MoneyDance for years and love it but I often need to pull data out of it for my accountant. I have no problem with doing this by saving a report in .csv format but the problem I have is that I get an "A$" in front of every amount. I realise that this is telling me that the currency is in Australian Dollars (That's where I live) but I don't want that as I need to set up some calculations and with "A$" in front of everything I cannot do that. Is there a way to turn off the currency and just get a figure without "A$" in front of it. I'm sure there must be but I can't see the flag to turn it off.

Help would be appreciated.
TCuffe - Australia

1. 1 Posted by macalves1 on Nov 12, 2013 @ 10:03 AM

   

   Hi TCuffe,

   I am a MD user, not someone from support, but I believe I can help you.

   You may find the Excel functions LEN and RIGHT to be just what you need to remove the currency signs.

   LEN function determines the character length of a cell text, and RIGHT function will give you the last characters in a text string, based on the number of characters you specify.

   If, for instance, H6 cell displays "A$ 1234.89" you can use the formula =RIGHT(H6;LEN(H6)-3), to give you the value you're looking for, in another cell of your choice. The -3 tells Excel to ignore the first 3 characters in the text (A+$+space) .

   So, just use a free column to calculate the amounts. In the first cell, type a formula like the one above and copy it to the other cells beneath it.

   I've attached a screenshot instead of a file, because my local settings differ from Australia's (we use "," as a decimal separator and "." as a thousand separator").

   Hope it helps

   Marco - Portugal

   • Screen_shot_2013-11-12_at_10.01.32.png 24.3 KB
   • Edit

2. 2 Posted by tcuffe on Nov 12, 2013 @ 11:54 AM

   

   Thanks Marco. Will try that out in the morning.

   Sent from my iPad

   • Edit

3. 3 Posted by -Kevin N. on Nov 12, 2013 @ 01:40 PM

   

   Hi TCuffe,

   Another possible solution may be to use Excel's 'Replace' feature, listed under the 'Edit' menu.

   Select the desired data range.
   Edit > Replace
   In the 'Find what:' field, type 'A$ ' (that's 'A$space' without the hash marks)
   Leave the 'Replace with:' field blank.
   Click 'Replace All'.

   HTH -Kevin N.

   • Edit

4. 4 Posted by dwg on Nov 12, 2013 @ 08:06 PM

   

   You could also just use a text editor (even notepad) to globally replace A$ with nothing.

   • Edit

5. 5 Posted by tcuffe on Nov 13, 2013 @ 12:02 AM

   

   Thanks everyone. Fixes the problem. Was hoping to fix it in MD but at least I can get what I need.

   • Edit

6. System closed this discussion on Mar 31, 2015 @ 04:05 PM.