tag:infinitekind.tenderapp.com,2009-01-14:/discussions/general-questions/123519-formatting-of-currency-data-transferred-from-reports-to-spreadsheets-via-copy-to-clipboardInfinite Kind: Discussion 2024-02-20T22:42:22Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/547703022022-06-23T15:26:47Z2022-06-24T11:56:03ZFormatting of currency data transferred from reports to spreadsheets via 'copy to clipboard'<div><p>Hi Michael,</p>
<p>We are sorry to hear about the problem you have encountered.</p>
<p>Unfortunately we are aware of this issue and it will require Java update to be resolved. In the meantime you could use the following workaround:</p>
<p>After generating the report, choose 'Save'.<br>
Change the 'Format' to 'Comma Delimited'- Encoded for Excel<br>
Then click 'Browse' and specify where you want to save the file.</p>
<p>Before saving, check the correct file format has been applied. Your file should be called 'YourFileName.csv'.<br>
If the file format is not included, you can add '<em>.csv</em>' (without the quotes) to the end of the file name.</p>
<p>This will create a comma delimited file that will open with Excel.</p>
<p>If you have already saved the file, you can navigate to it on your computer, and re-name the file from there, to include <em>.csv</em> at the end of the file name.</p>
<p>I hope this information is helpful. Please let us know if you have further questions or need more assistance.</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/547703022022-06-23T15:33:44Z2022-06-24T11:56:03ZFormatting of currency data transferred from reports to spreadsheets via 'copy to clipboard'<div><p>Thank you for your quick reply. At least this gives me a possible way<br>
forward.<br>
Regards<br>
MJ</p></div>Michael Johnstonetag:infinitekind.tenderapp.com,2009-01-14:Comment/547703022022-06-25T09:30:30Z2022-06-25T09:30:30ZFormatting of currency data transferred from reports to spreadsheets via 'copy to clipboard'<div><p>Another workaround if you don't need the pound sign (for instance you only use a single currencty) is to remove the "Value prefix" you have assigned to the currency in MD. Use Tools | Currencies, double-click on the currency and then either click the Edit button or this step my be unnecessary. to delete the pound sign from the Value Prefix field.</p>
<p>This will stop MD dynamically pre-pending the pound sign until you re-implement it in future.</p>
<ul>
<li>a fellow user.</li>
</ul></div>tgilbert666tag:infinitekind.tenderapp.com,2009-01-14:Comment/547703022022-06-25T15:07:58Z2022-06-25T15:07:58ZFormatting of currency data transferred from reports to spreadsheets via 'copy to clipboard'<div><p>many thanks. v useful</p>
<p>regards</p>
<p>MJ</p></div>Michael Johnstone