moderated
Re: Problems with Outlook 365
Office version 2019 applies only to the retail version of Office. If you are subscribed to Office 365 your version will still read something like 16.0.12026.20108 which is what it currently shows for me.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of
John Gurd via Groups.Io
Sent: Monday, September 16, 2019 12:39 AM To: main@jfw.groups.io Subject: Re: Problems with Outlook 365
How do I switch to the monthly channel for updates of Office 365? I’ve just tried to update and been advised my latest update was October 2018 and I am up-to-date. On checking I still appear to be on the 2016 build. I have 3 machines and they all report the same thing including one which is new on which 365 was installed 4 weeks ago. I am in the UK but I assume I should still be on the 2019 build.
Thanks
John John Gurd
|
|
moderated
Re: Need help with an Excel formula
Shirley Tracy
Hi Allen,
You must be reading my spread sheet. 😊 Absolutely on base. Thank you. That’s just what I wanted.
I have manually put in the starting balance (from the prior month), but the calculations were in error after that, so I knew something had to be wrong. That’s when I tried keying in the formula instead of copying it from sheet to sheet. Same problem. But what you gave me is just what I needed. Thanks.
So you really can teach an old dog new tricks. I’ll be 74 next month and I’m still learning.
Shirley
PS Thanks to everyone else who responded.
Shirley Tracy
From: Alan Lemly
Sent: Sunday, September 15, 2019 8:09 PM To: main@jfw.groups.io Subject: Re: Need help with an Excel formula
Hi Shirley,
What might be wrong with your formula is hard to diagnose with the information you've provided. I'll state what I think your bank debits and deposits spreadsheet looks like and we'll go from there. I suspect row 1 is your column headings and that column D contains debits, column E contains deposits, and column F contains a running balance. Assuming you use a different spreadsheet for each month, I would suggest that cell F2 be the opening balance for the month which should equal your closing balance from the previous month's spreadsheet. I personally would manually input the starting balance for cell F2 because I'm not a big fan of using formulas to bring amounts from other spreadsheets. Row 3 should contain the activity for the current month so the formula in cell F3 would be =(F2-D3+E3). I expect columns A through C contain date, description, and some other text field but those don't have formulas and don't seem to be giving you a problem.
I would check to make sure your opening balance in cell F2 is a manually input number and then I would input the formula I provided above into cell F3 and go from there. If you're still having problems, make sure columns D through F are formatted as numbers.
Good luck.
Alan Lemly
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shirley Tracy
Hi Listers,
First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?
Thank you.
Shirley
|
|
moderated
Re: Problems with Outlook 365
John Gurd
How do I switch to the monthly channel for updates of Office 365? I’ve just tried to update and been advised my latest update was October 2018 and I am up-to-date. On checking I still appear to be on the 2016 build. I have 3 machines and they all report the same thing including one which is new on which 365 was installed 4 weeks ago. I am in the UK but I assume I should still be on the 2019 build.
toggle quoted messageShow quoted text
Thanks John John Gurd
On 11 Sep 2019, at 3:53 pm, Cohn, Jonathan <jcohn@...> wrote:
|
|
moderated
Re: Need help with an Excel formula
Glenn / Lenny
toggle quoted messageShow quoted text
Some of my spreadsheets have quite a few formulas
in them, so I typically just save it under another name, and go in and delete
the variable data for a clean spreadsheet.
Glenn
|
|
moderated
Re: Need help with an Excel formula
Hi Shirley,
What might be wrong with your formula is hard to diagnose with the information you've provided. I'll state what I think your bank debits and deposits spreadsheet looks like and we'll go from there. I suspect row 1 is your column headings and that column D contains debits, column E contains deposits, and column F contains a running balance. Assuming you use a different spreadsheet for each month, I would suggest that cell F2 be the opening balance for the month which should equal your closing balance from the previous month's spreadsheet. I personally would manually input the starting balance for cell F2 because I'm not a big fan of using formulas to bring amounts from other spreadsheets. Row 3 should contain the activity for the current month so the formula in cell F3 would be =(F2-D3+E3). I expect columns A through C contain date, description, and some other text field but those don't have formulas and don't seem to be giving you a problem.
I would check to make sure your opening balance in cell F2 is a manually input number and then I would input the formula I provided above into cell F3 and go from there. If you're still having problems, make sure columns D through F are formatted as numbers.
Good luck.
Alan Lemly
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shirley Tracy
Sent: Sunday, September 15, 2019 2:11 PM To: main@jfw.groups.io Subject: Need help with an Excel formula
Hi Listers,
First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?
Thank you.
Shirley
|
|
moderated
Re: Does the latest ITuneds work with JFW 2019?
I wouldn’t quite call it a horror and if you have an iPhone you may not have a choice but to use it for a few things. But if all you are concerned about it having an app for your music, making playlists and playing them then I agree that iTunes wuldn’t be my first choice.
From: main@jfw.groups.io <main@jfw.groups.io>
On Behalf Of Jaffar Sidek
Sent: Friday, September 13, 2019 3:24 PM To: main@jfw.groups.io Subject: Re: Does the latest ITuneds work with JFW 2019?
Hi. I wouldn't wish ITune for Windows on my worst enemy. Stick to Winamp or Groove Music or Windows Media player even and they should do a more then adequate job of allowing you to organize your music collection. ITunes is excellent on the mac, but a horror on windows. Cheers! On 9/14/2019 2:07 AM, Kevin Meyers wrote:
|
|
moderated
Re: Does the latest ITuneds work with JFW 2019?
Except if it's a 32-bit app where the developer never bothered to change it 64-bit, in this case you maybe able to install it on your iPhone (not sure), but it sure won't run since only 64-bit apps will work.
toggle quoted messageShow quoted text
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of netbat66 Sent: Friday, September 13, 2019 11:21 AM To: main@jfw.groups.io Subject: Re: Does the latest ITuneds work with JFW 2019? if anyone still has i tunes version 12.60 i would not upgrade. this is the last version that allows you to backup your apps on your computer. at least if you have bought an app and it is removed from the apple app store you would still have it on your computer and could reinstall it. you can not do this with the newest i tunes version. -----Original Message----- From: Ralph Supernaw Sent: Friday, September 13, 2019 9:10 AM To: main@jfw.groups.io Subject: Does the latest ITuneds work with JFW 2019? Hi, I have been putting off letting ITunes update to the latest version. Before I do I thought I’d find out if I will regret it. Thanks.
|
|
moderated
Re: Windows 10 and emojis
David Diamond
I tried it in sending a message to myself via computer and even in a post on Facebook. It worked in both situations. 😊
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Maria Campbell Sent: September 15, 2019 4:08 PM To: main@jfw.groups.io Subject: Re: Windows 10 and emojis
I brought it up but I had to go to the desktop.
Maria Campbell
All that is necessary for evil to triumph is for good people to do nothing.
On 9/15/2019 7:06 PM, Kevin Meyers wrote: > Nothing happens when I press windows key and the period. Is there some > other keys I can bring this up? > > -----Original Message----- > From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard > Weitzel > Sent: Sunday, September 15, 2019 4:45 PM > To: main@jfw.groups.io > Subject: Re: Windows 10 and emojis > > Windows + Period brings up the emoji panel and you can arrow around or > if you type something like "face" or grin" it will show only emojis like that. > > -----Original Message----- > From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Randy > Barnett > Sent: Saturday, September 14, 2019 4:32 PM > To: main@jfw.groups.io > Subject: Re: Windows 10 and emojis > > After doing windows period Did you tab? > > Randy Barnett owner of soundtique > > On Sep 14, 2019, at 1:19 PM, Edward Green <ergreen1981@...> wrote: > > Hi all, > > I wondered whether anyone has found an accessible way to type emojis > in Windows 10 using JAWS 2019. > > I have tried by bringing up the Windows touch keyboard from the System > Tray, but don't seem to be able to enter the emojis using JAWS > commands on the physical keyboard - I have tried the touch cursor without success. > > I have had limited success in finding emojis on the screen itself, but > scrolling is a bit unreliable/at an awkward angle as I'm using a laptop. > > I have tried a couple of windows shortcuts which are meant to bring up > emojis - Windows semi-colon and Windows period, but they don't seem to work. > > Does anyone have any suggestions either things I can do differently > using the methods I've already tried or something else? > > Cheers, > > Ed > > > > > > > > > > > > >
|
|
moderated
Re: Need help with an Excel formula
Kevin Meyers <kevinmeyers@...>
I put your formula in my spread sheet and it works. Maybe add sum to the formula. Like:
=sum(E3-D3)+F2
Both ways worked in my spread sheet.
Kevin
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Shirley Tracy
Sent: Sunday, September 15, 2019 2:11 PM To: main@jfw.groups.io Subject: Need help with an Excel formula
Hi Listers,
First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?
Thank you.
Shirley
|
|
moderated
Re: Windows 10 and emojis
Maria Campbell
I brought it up but I had to go to the desktop.
toggle quoted messageShow quoted text
Maria Campbell lucky1inct@gmail.com All that is necessary for evil to triumph is for good people to do nothing.
On 9/15/2019 7:06 PM, Kevin Meyers wrote:
Nothing happens when I press windows key and the period. Is there some other
|
|
moderated
Re: Windows 10 and emojis
Kevin Meyers <kevinmeyers@...>
Nothing happens when I press windows key and the period. Is there some other
toggle quoted messageShow quoted text
keys I can bring this up?
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel Sent: Sunday, September 15, 2019 4:45 PM To: main@jfw.groups.io Subject: Re: Windows 10 and emojis Windows + Period brings up the emoji panel and you can arrow around or if you type something like "face" or grin" it will show only emojis like that. -----Original Message----- From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Randy Barnett Sent: Saturday, September 14, 2019 4:32 PM To: main@jfw.groups.io Subject: Re: Windows 10 and emojis After doing windows period Did you tab? Randy Barnett owner of soundtique On Sep 14, 2019, at 1:19 PM, Edward Green <ergreen1981@gmail.com> wrote: Hi all, I wondered whether anyone has found an accessible way to type emojis in Windows 10 using JAWS 2019. I have tried by bringing up the Windows touch keyboard from the System Tray, but don't seem to be able to enter the emojis using JAWS commands on the physical keyboard - I have tried the touch cursor without success. I have had limited success in finding emojis on the screen itself, but scrolling is a bit unreliable/at an awkward angle as I'm using a laptop. I have tried a couple of windows shortcuts which are meant to bring up emojis - Windows semi-colon and Windows period, but they don't seem to work. Does anyone have any suggestions either things I can do differently using the methods I've already tried or something else? Cheers, Ed
|
|
moderated
Re: Windows 10 and emojis
Windows + Period brings up the emoji panel and you can arrow around or if you type something like "face" or grin" it will show only emojis like that.
toggle quoted messageShow quoted text
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Randy Barnett Sent: Saturday, September 14, 2019 4:32 PM To: main@jfw.groups.io Subject: Re: Windows 10 and emojis After doing windows period Did you tab? Randy Barnett owner of soundtique On Sep 14, 2019, at 1:19 PM, Edward Green <ergreen1981@gmail.com> wrote: Hi all, I wondered whether anyone has found an accessible way to type emojis in Windows 10 using JAWS 2019. I have tried by bringing up the Windows touch keyboard from the System Tray, but don't seem to be able to enter the emojis using JAWS commands on the physical keyboard - I have tried the touch cursor without success. I have had limited success in finding emojis on the screen itself, but scrolling is a bit unreliable/at an awkward angle as I'm using a laptop. I have tried a couple of windows shortcuts which are meant to bring up emojis - Windows semi-colon and Windows period, but they don't seem to work. Does anyone have any suggestions either things I can do differently using the methods I've already tried or something else? Cheers, Ed
|
|
moderated
Re: Need help with an Excel formula
Marty Hutchings
I would need to know your columb titles before I could help you. I
also use Excel for bank ledgers, but your formula is a little different than
mine.
Love in
Christ
Marty For our struggle is not against flesh and blood, but against the rulers, against the powers, against the world forces of this darkness, against the spiritual forces of wickedness in the heavenly places. Therefore, take up the full armor of God, so that you will be able to resist in the evil day, and having done everything, to stand firm. Ephesians 6:12, 13
From: Shirley Tracy
Sent: Sunday, September 15, 2019 2:11 PM
Subject: Need help with an Excel formula Hi Listers,
First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?
Thank you.
Shirley
|
|
moderated
Re: Need help with an Excel formula
Glenn / Lenny
toggle quoted messageShow quoted text
Hi Shirley,
I find it easiest to just copy the contents of the
cell with the formula and pasting it elsewhere.
So I would have both spread sheets open, and go to
the cell where the formula works, and do control + C to copy, and control +
tab to the other spreadsheet and move to where you want the formula, and paste
it with control + V.
HTH.
Glenn
|
|
moderated
Need help with an Excel formula
Shirley Tracy
Hi Listers,
First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?
Thank you.
Shirley
|
|
moderated
Re: Absolutely Essential Information to Share When You Have an Issue and How to Get It
David Diamond
True however, some don’t know those things so it is good you provided steps to do that. Like I said, it is a symbiotic relationship. When someone calls me, often they just say, “My dog has issues.” It is up to me to assess by asking the correct questions what those issues are.
From: main@jfw.groups.io <main@jfw.groups.io>
On Behalf Of Brian Vogel
Sent: September 15, 2019 11:30 AM To: main@jfw.groups.io Subject: Re: Absolutely Essential Information to Share When You Have an Issue and How to Get It
On Sun, Sep 15, 2019 at 12:27 PM, David Diamond wrote:
Indeed, but OS Version, Screen Reader Version, and specific software version are the patient's responsibility, and the rough equivalent of Name, Address, and Phone Number. Brian - Windows 10 Pro, 64-Bit, Version 1903, Build 18362 Many of the insights of the saint stem from his experience as a sinner. ~ Eric Hoffer
|
|
moderated
Re: Absolutely Essential Information to Share When You Have an Issue and How to Get It
On Sun, Sep 15, 2019 at 12:27 PM, David Diamond wrote:
So it’s up to the doctor to ask the right questions. It is, a symbiotic relationship.Indeed, but OS Version, Screen Reader Version, and specific software version are the patient's responsibility, and the rough equivalent of Name, Address, and Phone Number. It needs to be automatically provided, not pried out each and every time. -- Brian - Windows 10 Pro, 64-Bit, Version 1903, Build 18362 Many of the insights of the saint stem from his experience as a sinner. ~ Eric Hoffer
|
|
moderated
Re: getting rid of inline objects in word
JM Casey
Haha..I wouldn’t have said anything, except seeing “carrot” there really cracked me up. I use a braille display more than speech nowadays so these things just jump out at me more.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Kimsan via Groups.Io
Sent: September 15, 2019 2:27 AM To: main@jfw.groups.io Subject: Re: getting rid of inline objects in word
Jm Casey, Lmao, my bad. I just went with the first spell check suggestion.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of JM Casey
Hey. Glad that method worked for you. It didn’t exactly work for me when I tried it last, but that was a large document OCRed by Adobe Aacrobat and converted to a word document. There may have been all sorts of weird issues with it.
BTW, it’s “caret”, not “carrot”, the vegetable. 8grins*
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Kimsan via Groups.Io
Hi, I found the answer. CTRL h for find and replace, type carrot g, in the next box leave it empty, then hit replace all. All gone.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Kimsan via Groups.Io
Hi, Jaws 2019, windows 10 pro latest and word 2016.
I press CTRL shift o, there are 218 inline objects, I thought by selecting all with CTRL a and tapping delete would do the trick, but to no avail. How can I quickly remove these? Thank you, Sincerely, Kimsan Song
|
|
moderated
Re: Scanning a document in K1000 and Open Book
Ann Byrne
The OpenBook setting doesn't really maintain the format despite what it says. If I needed something exact, I would go with a commercial program like Abbyy fine reader or Prismo. Or even the native ocr package that comes with your scanner.
toggle quoted messageShow quoted text
or At 11:26 AM 9/15/2019, you wrote:
IN Openbook, there is an exact view setting that tries to maintain the original format.
|
|
moderated
Re: Does the latest ITuneds work with JFW 2019?
Glenn / Lenny
toggle quoted messageShow quoted text
You will want to take the quotes out of
this.
Also, mine work better if I keep the M3U file in
the same folder as the music and remove the part of the path of each song up to
the folder where the music folders are.
Make sure that the folders don't start with a
backslash.
Glenn
|
|