Importing from MS Money - currency format problem

Page 1 of 1
2 posts
Importing from MS Money - currency format problem

summitmcl
New MMEX User

Posts: 5
Joined: Fri Apr 28, 2017 5:23 am
Hi, I've imported my data from MS Money and everything appeared to be going well - it didn't import the recurring transactions, but that didn't take too long to add manually. I also noted that the opening balance was incorrect, but managed to fudge that. However, I suspect there was more wrong with the opening balance than I initially realised.

I wanted to create a daily cash flow graph similar to that in MS Money, so cut and pasted this data into Excel, but could not produce a graph. Eventually I realised that the balance data was in an invalid format with a space after the thousands - 1 234.56 instead of 1,234.56 or 1234.56. I can now see that the balance data imported with the gap. What can I do to correct this?
Thanks
Terry
Re: Importing from MS Money - currency format problem

summitmcl
New MMEX User

Posts: 5
Joined: Fri Apr 28, 2017 5:23 am
In the absence of any reply I went on puzzling about this problem myself and found a solution. I hope this may be useful to someone else.

In the currency dialog box I selected UK Pound and then Edit. The currency manager opened and I could see the "," I had selected for the grouping character - a cumbersome way of saying ,000s. I found that the standard "," actually had a space in front of it, so I removed it. Problem solved.
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 1 guest

cron