tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/61984-copying-data-to-spreadsheetInfinite Kind: Discussion 2020-07-14T22:59:14Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/484551082020-07-10T10:27:00Z2020-07-10T10:27:00ZCopying data to spreadsheet<div><p>just a user,</p>
<p>Have you had any success by selecting the column involved and changing the format to numbers, or currency?</p></div>mhoggietag:infinitekind.tenderapp.com,2009-01-14:Comment/484551082020-07-10T11:38:02Z2020-07-10T11:38:02ZCopying data to spreadsheet<div><p>Yep. tried that.<br>
Thanks anyway</p></div>christine joytag:infinitekind.tenderapp.com,2009-01-14:Comment/484551082020-07-10T16:57:09Z2020-07-10T16:57:10ZCopying data to spreadsheet<div><p>You don’t say what version of MD you are using.</p>
<p>This issue was corrected in a preview version sometime ago</p>
<p><code>Moneydance build 1903 (Tue, 11 Feb 2020 22:58:00 +0000) * changed report copy-to-clipboard contents back to tab-delimited</code></p>
<p>Download the current preview version here:-<br>
<a href="https://infinitekind.com/preview">https://infinitekind.com/preview</a></p>
<p>just a user</p></div>jeff_ltag:infinitekind.tenderapp.com,2009-01-14:Comment/484551082020-07-11T10:48:38Z2020-07-11T10:48:39ZCopying data to spreadsheet<div><p>Thanks Jeff. Am on 2019.3 1880. Will try the preview.</p></div>christine joytag:infinitekind.tenderapp.com,2009-01-14:Comment/484551082020-07-11T11:13:13Z2020-07-11T11:13:13ZCopying data to spreadsheet<div><p>I'm a fellow user.</p>
<p>It is not unusual for spreadsheets to choke on the currency indicators.</p>
<p>I can think of two approaches to this.</p>
<ol>
<li>
<p>Edit the currency in Moneydance and remove the prefix.</p>
</li>
<li>
<p>In many spreadsheets you are given options as to what characters are to be considered as delimiters. If you current prefix says includes something like a $ sign you can set this as one of the field separators and this should remove the currency indicator from the amount field.</p>
</li>
</ol></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/484551082020-07-12T09:50:28Z2020-07-12T09:50:30ZCopying data to spreadsheet<div><p>I'm a fellow user who also finds this happening sometimes, but not just with Moneydance. Excel sometimes thinks pasted-in values with currency symbols are text and sometimes recognises that they're numbers displayed as currency, and I don't know what the rule is - so I've learnt workarounds. Here are two.</p>
<ol>
<li>
<p>For occasional use<br>
If all the currency characters are the same (e.g. all £), remove them all in one go. Highlight the column, press Ctrl-H for find-and-replace, put £ (or whatever) in the Find box and leave the Replace box empty, then Replace All.</p>
</li>
<li>
<p>For often pasting into a larger analysis spreadsheet.<br>
Set up another column in which each cell is the pasted-in currency value plus zero e.g. =b8+0. This will be happy with numbers, currency-text values. blanks, etc. You can then do analysis on that column.</p>
</li>
</ol>
<p>Hope this helps!</p></div>Bentag:infinitekind.tenderapp.com,2009-01-14:Comment/484551082020-07-14T09:19:53Z2020-07-14T09:19:53ZCopying data to spreadsheet<div><p>Thanks for the suggestions Ben</p>
<p>Christine</p></div>christine joy