duck
Member of DD Central
Posts: 2,603
Likes: 5,835
|
Post by duck on Feb 2, 2016 8:02:51 GMT
For years I have cut'n pasted the 'schedule of payments' for each loan that I am invested in and dumped it in Excel.
It has always been the case that £ and p have been separated into separate cells which I have then combined into a new cell ...... =a+(b/100) .... simple.
Today I cannot perform this task I get the hated #VALUE!
At the weekend I 'upgraded' to Windows 10 and wonder if this is the issue but if I manually enter the values the formula works correctly which suggests to me that Excel is failing to recognise the characters that have been cut'n pasted.
Anybody had/having similar issues?
|
|
registerme
Member of DD Central
Posts: 6,233
Likes: 6,038
|
Post by registerme on Feb 2, 2016 8:23:52 GMT
Win10 and Excel 2010 here and it works fine. I've never done what you've described so haven't fiddled with anything / changed anything.
|
|
duck
Member of DD Central
Posts: 2,603
Likes: 5,835
|
Post by duck on Feb 2, 2016 9:59:09 GMT
Having had a 'play' with the cut'n paste schedule of payments it is the £ column that is causing me issues.
Entries are now coming across as (for example) £4.
Not certain if the full stop was there before. No changing of format (General, Number, Currency Accounting ....) makes any difference but if you manually enter '4' everything works ....
Looks like my automated spreadsheet will need some 'manual intervention' in future!
|
|
adrianc
Member of DD Central
Posts: 9,045
Likes: 4,841
|
Post by adrianc on Feb 2, 2016 10:13:09 GMT
What happens if you bring the VALUE() function into the formula?
|
|
duck
Member of DD Central
Posts: 2,603
Likes: 5,835
|
Post by duck on Feb 2, 2016 10:27:23 GMT
.....not tried that yet. Need to have a further 'play' later since I hate 'manual manipulation', so easy to make a mistake/have a dyslectic finger.
|
|
ferdy
Member of DD Central
Posts: 166
Likes: 47
|
Post by ferdy on Feb 2, 2016 11:52:48 GMT
Hi
Do you mean the 'Repayments by month' page/screen (either by contract or by date) ?
If so there is a download button at the bottom and you can create a csv file.
If not, not sure which page/screen you mean
Cheers
|
|
duck
Member of DD Central
Posts: 2,603
Likes: 5,835
|
Post by duck on Feb 2, 2016 12:37:38 GMT
Hi .... If not, not sure which page/screen you mean Cheers From 'Your Portfolio' hit say '5 year Income' which displays all the 5 year contracts. Pick a contract and hit 'view'. Then hit the + for schedule of payments .... it is those details that I work with.
|
|
ferdy
Member of DD Central
Posts: 166
Likes: 47
|
Post by ferdy on Feb 2, 2016 13:21:49 GMT
I see. I had n't previously played with those stats.
I use Win 8 and Open Office. The £/p come across ok. Do you get asked for separator options with Excel?
|
|
duck
Member of DD Central
Posts: 2,603
Likes: 5,835
|
Post by duck on Feb 2, 2016 15:10:09 GMT
There are certainly ways round it, just surprised if the RS format had changed since it has come across fine since the year dot!
Just more interested if it was an RS change or another annoying 'glitches' that are showing up due to my Windows 10 update.
|
|
|
Post by GSV3MIaC on Feb 2, 2016 16:05:23 GMT
Probably the latter. My free win10 update lasted 40 minutes (a tenth the time it took to install), and I am still combing out problems from the restore to Win7 (like "most scheduled tasks got trashed"). Obvious benefits .. well, I guess "a few more years of support" (using the term 'support' a bit loosely). Obvious drawbacks .. hmm, life's a bit too short to list them all... anyway I only looked for 40 minutes (not fully functioning either).
No I ain't a luddite - I just upgraded my 2009 acer laptop from vista (spit!) and rotating media to Win7 on an SSD, which was nearly as horrid an experience, but a lot more worthwhile. Win10? Worth every penny, IMHO. Well, if you are at 8, maybe it's an upgrade...
|
|
duck
Member of DD Central
Posts: 2,603
Likes: 5,835
|
Post by duck on Feb 2, 2016 16:25:27 GMT
Thanks gsv3miac settled my mind perfectly I've found a couple of things that I like in Win10 so I might keep it (still prefer XP that I have on a laptop to run Finite Element Analysis) but I'm certainly finding a few 'issues'. EDIT GSV3MIaC won't hold Caps above!
|
|
|
Post by GSV3MIaC on Feb 2, 2016 18:10:15 GMT
I liked XP too, but support (and geriatric hardware) is now becoming an issue .. fwiw Win7 joined my OK list, along with Win2000, and XP. ME, Vista (spit) and 8, are in the sin-bin. 10 .. was not impressed, but then it has to be better than 8, doesn't it?! (we don't even consider 3.1 to be actual WinDoze .. too much of Doze and very little Win)
The issue with laptop upgrades is that lots of the damn hardware is custom and thus irreplaceable/unupgradeable in most cases, so upgrading the OS requires copious prayers and hunting under rugs for new drivers, from people like Validity (fingerprint scanner) who have now ceased to exist. Grr.
[Sorry about the caps .. it's really GSV3MiaC .. 'in' and 'a' don't get caps, in this pseudo-Germanic-capitalise-all-the-serious-Nouns universe.]
|
|