Wow, that show formula as text is a new one on me. I just went into Numbers and checked because I have an edited formulas in a while and the problem that was spoken of no longer seems to occur for me. Our wing threw the formula in the formula editor does read out each token. That’s a great help Tim the show text is formula business.
Sent from my IPhone > On May 24, 2020, at 11:05 PM, 'Tim Kilburn' via MacVisionaries > <[email protected]> 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 > <[email protected]> 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 <[email protected]> wrote: >>> >> >> That is how I do it. >> >> >> Sent from my iPhone >> >>>> On May 24, 2020, at 7:34 PM, 'Tim Kilburn' via MacVisionaries >>>> <[email protected]> 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 >>> <[email protected]> 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: >>> [email protected] and your owner is Cara Quinn - you can reach Cara at >>> [email protected] >>> >>> The archives for this list can be searched at: >>> http://www.mail-archive.com/[email protected]/ >>> --- >>> 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 [email protected]. >>> To view this discussion on the web visit >>> 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: >>> [email protected] and your owner is Cara Quinn - you can reach Cara at >>> [email protected] >>> >>> The archives for this list can be searched at: >>> http://www.mail-archive.com/[email protected]/ >>> --- >>> 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 [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/macvisionaries/F5C473D6-AA36-4340-9898-38EF15F1B4FB%40me.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: > [email protected] and your owner is Cara Quinn - you can reach Cara at > [email protected] > > The archives for this list can be searched at: > http://www.mail-archive.com/[email protected]/ > --- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/macvisionaries/607C215B-C0B9-4FA4-BE60-2BD7C3CFC358%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: > [email protected] and your owner is Cara Quinn - you can reach Cara at > [email protected] > > The archives for this list can be searched at: > http://www.mail-archive.com/[email protected]/ > --- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/macvisionaries/D711282B-A3DA-4E3A-A165-452BEC1CC044%40me.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: [email protected] and your owner is Cara Quinn - you can reach Cara at [email protected] The archives for this list can be searched at: http://www.mail-archive.com/[email protected]/ --- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/macvisionaries/B249FBC2-AE2F-4323-9EE7-44946D3BD1F4%40gmail.com.
