That fixed it. Thanks
> On May 24, 2020, at 11:05 PM, 'Tim Kilburn' via MacVisionaries > <macvisionaries@googlegroups.com> wrote: > > Hi, > > After pressing option-return, the cursor is placed at the end of the formula. > The step that you’re missing is to VO-left to the “Formula Options” button. > VO-space on this button and select the “Show Formula as text” item. Now the > formula within the cell is editable text, including the cell references. So, > yes, using this process, you are able to change B40 to B45 simply by arrowing > within the formula until the cursor is after the 0, pressing the Delete key, > then typing the number 5, and finally pressing the return. Be sure to use > the “Show Formula As Text” item, not the “Convert to Text in Cell” item as > the latter will change the formula to text and the formula will be displayed > in the cell and no calculation will happen. Of course, you can fix this by > arrowing to the front of the text and adding the “=“ sign then pressing > return. > > HTH. > > Later… > > > Tim Kilburn > Jamf Certified Tech > Apple Teacher > (with Swift Playgrounds Recognition) > Fort McMurray, AB Canada > > On May 24, 2020, at 7:21 PM, 'Robert Cole' via MacVisionaries > <macvisionaries@googlegroups.com <mailto:macvisionaries@googlegroups.com>> > wrote: > > Ok, are you saying that I cannot delete just the b40 > and replace it with b45, without retyping most of the formula? > Sent from my iPhone > >> On May 24, 2020, at 9:15 PM, Robert Cole <mr.robertc...@icloud.com >> <mailto:mr.robertc...@icloud.com>> wrote: >> >> >> That is how I do it. >> >> >> Sent from my iPhone >> >>> On May 24, 2020, at 7:34 PM, 'Tim Kilburn' via MacVisionaries >>> <macvisionaries@googlegroups.com <mailto:macvisionaries@googlegroups.com>> >>> wrote: >>> >>> Hi, >>> >>> Press option-return on the cell you wish to edit. then arrow through the >>> formula to make changes. >>> >>> Later… >>> >>> >>> Tim Kilburn >>> Jamf Certified Tech >>> Apple Teacher >>> (with Swift Playgrounds Recognition) >>> Fort McMurray, AB Canada >>> >>> On May 24, 2020, at 4:05 PM, 'Robert Cole' via MacVisionaries >>> <macvisionaries@googlegroups.com <mailto:macvisionaries@googlegroups.com>> >>> wrote: >>> >>> Dear List, >>> For the longest time, I have been copying the formula and pasteing it into >>> Text Edit, to edit it. >>> For example, my formula is >>> SUM(B6:B40) >>> If I tried to edit in numbers, VoiceOver will not read by characters. It >>> just repeats >>> SUM sum ) >>> Pressing up or down arrow gets the same results. >>> I even tried quick nav set to characters but VoiceOver refuse to cooperate. >>> Any suggestions? >>> Thanks, >>> Rob >>> >>> >>> -- >>> The following information is important for all members of the Mac >>> Visionaries list. >>> >>> If you have any questions or concerns about the running of this list, or if >>> you feel that a member's post is inappropriate, please contact the owners >>> or moderators directly rather than posting on the list itself. >>> >>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: >>> mk...@ucla.edu <mailto:mk...@ucla.edu> and your owner is Cara Quinn - you >>> can reach Cara at caraqu...@caraquinn.com <mailto:caraqu...@caraquinn.com> >>> >>> The archives for this list can be searched at: >>> http://www.mail-archive.com/macvisionaries@googlegroups.com/ >>> <http://www.mail-archive.com/macvisionaries@googlegroups.com/> >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to macvisionaries+unsubscr...@googlegroups.com >>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/macvisionaries/A28409D7-7BEE-4D13-B735-7AED0A20557C%40icloud.com >>> >>> <https://groups.google.com/d/msgid/macvisionaries/A28409D7-7BEE-4D13-B735-7AED0A20557C%40icloud.com>. >>> >>> >>> -- >>> The following information is important for all members of the Mac >>> Visionaries list. >>> >>> If you have any questions or concerns about the running of this list, or if >>> you feel that a member's post is inappropriate, please contact the owners >>> or moderators directly rather than posting on the list itself. >>> >>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: >>> mk...@ucla.edu <mailto:mk...@ucla.edu> and your owner is Cara Quinn - you >>> can reach Cara at caraqu...@caraquinn.com <mailto:caraqu...@caraquinn.com> >>> >>> The archives for this list can be searched at: >>> http://www.mail-archive.com/macvisionaries@googlegroups.com/ >>> <http://www.mail-archive.com/macvisionaries@googlegroups.com/> >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to macvisionaries+unsubscr...@googlegroups.com >>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/macvisionaries/F5C473D6-AA36-4340-9898-38EF15F1B4FB%40me.com >>> >>> <https://groups.google.com/d/msgid/macvisionaries/F5C473D6-AA36-4340-9898-38EF15F1B4FB%40me.com?utm_medium=email&utm_source=footer>. > > -- > The following information is important for all members of the Mac Visionaries > list. > > If you have any questions or concerns about the running of this list, or if > you feel that a member's post is inappropriate, please contact the owners or > moderators directly rather than posting on the list itself. > > Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: > mk...@ucla.edu <mailto:mk...@ucla.edu> and your owner is Cara Quinn - you can > reach Cara at caraqu...@caraquinn.com <mailto:caraqu...@caraquinn.com> > > The archives for this list can be searched at: > http://www.mail-archive.com/macvisionaries@googlegroups.com/ > <http://www.mail-archive.com/macvisionaries@googlegroups.com/> > --- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to macvisionaries+unsubscr...@googlegroups.com > <mailto:macvisionaries+unsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/macvisionaries/607C215B-C0B9-4FA4-BE60-2BD7C3CFC358%40icloud.com > > <https://groups.google.com/d/msgid/macvisionaries/607C215B-C0B9-4FA4-BE60-2BD7C3CFC358%40icloud.com?utm_medium=email&utm_source=footer>. > > > -- > The following information is important for all members of the Mac Visionaries > list. > > If you have any questions or concerns about the running of this list, or if > you feel that a member's post is inappropriate, please contact the owners or > moderators directly rather than posting on the list itself. > > Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: > mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at > caraqu...@caraquinn.com > > The archives for this list can be searched at: > http://www.mail-archive.com/macvisionaries@googlegroups.com/ > <http://www.mail-archive.com/macvisionaries@googlegroups.com/> > --- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to macvisionaries+unsubscr...@googlegroups.com > <mailto:macvisionaries+unsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/macvisionaries/D711282B-A3DA-4E3A-A165-452BEC1CC044%40me.com > > <https://groups.google.com/d/msgid/macvisionaries/D711282B-A3DA-4E3A-A165-452BEC1CC044%40me.com?utm_medium=email&utm_source=footer>. -- The following information is important for all members of the Mac Visionaries list. If you have any questions or concerns about the running of this list, or if you feel that a member's post is inappropriate, please contact the owners or moderators directly rather than posting on the list itself. Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: mk...@ucla.edu and your owner is Cara Quinn - you can reach Cara at caraqu...@caraquinn.com The archives for this list can be searched at: http://www.mail-archive.com/macvisionaries@googlegroups.com/ --- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/macvisionaries/6FA82BE9-D31A-416A-9FF0-32505E0BD6DE%40icloud.com.
