Kenneth BarberKenneth Barber

My feedback

  1. 2 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Kenneth BarberKenneth Barber commented  · 

      I was thinking more along the lines of converting time zone abbreviations (https://en.wikipedia.org/wiki/List_of_time_zone_abbreviations). So even though the Eastern Time Zone can observe EST or EDT depending on the time of year, EST is always UTC−05:00 and EDT is always UTC−04:00. Then we don't run into issues of region or time of year.

      I realize that this doesn't address the language issue, but this can perhaps be addressed by using abbreviations in the language that the user is using for Excel.

      Kenneth BarberKenneth Barber shared this idea  · 
    • 2 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        Kenneth BarberKenneth Barber supported this idea  · 
      • 2 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          Kenneth BarberKenneth Barber commented  · 

          Having a grand total at the top or on the left actually makes more sense, since those are the numbers that people care about the most, and people naturally read anything starting from the top or left.

        • 1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            Kenneth BarberKenneth Barber commented  · 

            innerestin' word choice, m8

          • 1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              Kenneth BarberKenneth Barber commented  · 

              Copy the random data and paste as values?

            • 7 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                Kenneth BarberKenneth Barber supported this idea  · 
              • 1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
                  Kenneth BarberKenneth Barber commented  · 

                  You can import SWF files into Excel and play them. Alternatively, you can find games made directly in Excel. For example, here is Tetris (works on Excel 2007 and Excel 2010 only):
                  http://www.mediafire.com/file/m7cl0j2273fhtzz/Kenneth_Barber_Tetris.xlsb

                  You might also be interested to know that Excel 97 had a flight simulator in it.

                • 2 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    Kenneth BarberKenneth Barber commented  · 

                    It's "asterisk", not "astrix".

                  • 5 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      Kenneth BarberKenneth Barber commented  · 

                      The possessive is easy to correct with the SUBSTITUTE function. Substitute all 'S with 's.

                      The ordinal numbers are a bit harder. I can't think of a good way to do those replacements. Maybe 10 SUBSTITUTE functions, one for each digit?

                    • 1 vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        Kenneth BarberKenneth Barber commented  · 

                        See this (assuming that you are comparing Excel 2003 with whatever version that you are getting frustrated with):
                        https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8913190-bring-back-the-chart-wizzard

                      • 2 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
                          Kenneth BarberKenneth Barber commented  · 

                          Wouldn't a medical expense tracker for tax purposes depend on the region that you are in? Each region does its taxes differently.

                        • 1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            Kenneth BarberKenneth Barber commented  · 

                            Not sure why you mentioned PowerPoint.

                          • 1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              Kenneth BarberKenneth Barber commented  · 

                              You are not tackling the right issue. If you are accidentally pressing Close so often that it becomes a problem, then that is your issue. The issue is not so much the fact that Excel boots you out of edit mode. Maybe it's a user interface issue, or maybe you are not being careful enough about what you click on.

                            • 238 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                Hi Ken,

                                Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

                                thanks
                                ash [MS XL]

                                Kenneth BarberKenneth Barber supported this idea  · 
                              • 1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                • 901 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    We are actively working on a plan to provide PivotCharts in Excel Mac desktop.

                                    7/26/16
                                    As noted previously, we are actively working on providing PivotCharts in Excel Mac desktop. This is a large project with many dependencies. As such, we cannot provide any details on when it will be available. However, I’ll update this thread when we get closer to a release timeframe.

                                    Thanks,
                                    Scott [MSFT]

                                    Kenneth BarberKenneth Barber supported this idea  · 
                                  • 1,792 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      476 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                      Kenneth BarberKenneth Barber supported this idea  · 
                                    • 0 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        Kenneth BarberKenneth Barber commented  · 

                                        Are you using absolute references? Use the formula =AVERAGE($A$1:A1). Drag that down to get:
                                        =AVERAGE($A$1:A1)
                                        =AVERAGE($A$1:A2)
                                        =AVERAGE($A$1:A3)
                                        etc.

                                      • 1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Excel Online » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                          Kenneth BarberKenneth Barber shared this idea  · 
                                        • 1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            Kenneth BarberKenneth Barber commented  · 

                                            If I have a formula =A1<A2, which will evaluate to either TRUE or FALSE, what are you suggesting that the output should look like?

                                          ← Previous 1 3 4 5 27 28

                                          Feedback and Knowledge Base