+ Reply to Thread
Results 1 to 36 of 36

Newest Excel Version (For Mac)--> Problems

  1. #1
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Angry Newest Excel Version (For Mac)--> Problems

    On introducing a number like e.g. 456 in a "number"-formatted cell (with no decimals) the sheet shows 4,56 .

    I can only obtain the correct respresentation 456 when I introduce =456 in the cell.

    I don't find the way to correct this. How to do it ?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,873

    Re: Newest Excel Version (For Mac)--> Problems

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,522

    Re: Newest Excel Version (For Mac)--> Problems

    Not sure if it's the same on a Mac, but on a PC it's File, Options, Advanced and under "Editing Options" look for "Automatically insert a decimal point" & uncheck it.

  4. #4
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    Thank you !

  5. #5
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    Nothing of the kind on Mac :-(

  6. #6
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    Subscription version Ms Excel for Mac Version 16.47.1

    There is also a problem in simple addition (sum) : I now have to enter manually every inditvduale operator "+" between the numbers :-(

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,803

    Re: Newest Excel Version (For Mac)--> Problems

    On a Mac, it's Excel - Preferences, then select the Edit section, then uncheck the 'Display this number of decimal places' option.
    Rory
    I drink, and I know things

  8. #8
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    That's it ! This is different from the previous XLSX-version and tricky !

  9. #9
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    So far, so good, but I'm still looking for addition by clicking disparate cells, wthout having to interplace a "+"-sign. Selecting 2 subsequent cells makes only the latest tot be selected.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,873

    Re: Newest Excel Version (For Mac)--> Problems

    That's done now, thanks. I will tidy the thread for you.

  11. #11
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,803

    Re: Newest Excel Version (For Mac)--> Problems

    Quote Originally Posted by Jan G View Post
    So far, so good, but I'm still looking for addition by clicking disparate cells, wthout having to interplace a "+"-sign. Selecting 2 subsequent cells makes only the latest tot be selected.
    You have to hold the Cmd key down while clicking all the subsequent cells.

  12. #12
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    Okay, that too is completely new (and cannot be reset ?)

  13. #13
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,803

    Re: Newest Excel Version (For Mac)--> Problems

    You can enable Click to Add mode in the same Edit section in Preferences.

  14. #14
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    This doesn't work. No "Click to Add"-mode findable. Moreover, the Cmd-trick doesn't work either

  15. #15
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,803

    Re: Newest Excel Version (For Mac)--> Problems

    It should be there - see attachment
    Attached Images Attached Images

  16. #16
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    I believe you, but in my Dutch version it should but is isn't.
    Attachment 727414

  17. #17
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,803

    Re: Newest Excel Version (For Mac)--> Problems

    I can't see that attachment. You need to click the Go Advanced button, then the Manage Attachments links, then upload the picture that way.

    If Cmd doesn't work, does Ctrl?

  18. #18
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    Nope, I tried al buttons

    NL.jpg
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Jan G; 04-08-2021 at 09:49 AM.

  19. #19
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    In the latest Dutch EXCEL there is simply no "Enable Click to Add" as there always was before.

  20. #20
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,873

    Re: Newest Excel Version (For Mac)--> Problems

    Maybe a stupid question, but are you sure the version number you originally shared in your profile was correct? A Google search told me that it was the 365 subscription version, but what you are saying points to a standalone version. What does it say on the splash screen when you launch Excel?

  21. #21
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    I asked for MS 365 in the shop and they installed it, but I don't see any reference to that on the parcel.

  22. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,873

    Re: Newest Excel Version (For Mac)--> Problems

    And on the splash screen when you launch it - what does it say? Does it look anything like mine?
    Attached Images Attached Images
    Last edited by AliGW; 04-08-2021 at 11:44 AM.

  23. #23
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    No splash screen. A window full of templates

  24. #24
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,873

    Re: Newest Excel Version (For Mac)--> Problems

    Screenshot, please! Every version should have a splash screen when you launch it!!!

    What does it say about your version on the File | Account page?

  25. #25
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    Sorry NO SPLASH SCREEN when I Launch. Here is what I get on launching (--> Google Translate) Attachment 727456

  26. #26
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,873

    Re: Newest Excel Version (For Mac)--> Problems

    OK - I think it's just launching so fast you don't get the splash screen (or Mac doesn't have one, but as a Mac-hater, I wouldn't know for sure).

    Sorry - I'm out of ideas. It all ooks as it should be. What does it say under File | Account?

  27. #27
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    What does a Mac-hater do on a Excel forum ? Excel was born, developed and educated on Mac while Dos/Windows were hooked on Lotus and denied Excel.
    You may know that I hate everything Bill Gates & Co do ! Now he's in the vaccine-business, good luck !

  28. #28
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,873

    Re: Newest Excel Version (For Mac)--> Problems

    Each to his own!

    I joined in 2013 - Excel ws available for PCs long before that.

    But back to the question: once again, WHAT does it say under File | Account in your copy of Excel?

    I am trying to work out from these clues why your version might be missing the features you need.

  29. #29
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,803

    Re: Newest Excel Version (For Mac)--> Problems

    I'm on Insider and my version is 16.49, so a little bit more up to date than 16.47.1

    From the looks of the dialog, it appears that there is room there for the missing options, so perhaps they are yet to come in that version. I've never heard of a version that doesn't work using either the Ctrl or Cmd keys for multiple cell selections - perhaps it is a setting in your Keyboard options in system preferences?

  30. #30
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    OK, there is probably no problem in the Engoish version, but they installed a Dutch version on my Mac . A Dutch 16.49-version is probably not available yet

  31. #31
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    I see, this old-but-never-retiring engineer is talking to a young and smart ICT-girl. I gave you all I had about my EXCEL-version bought yesterday. But this doesn't matter .... It's always English first. I know this for a long long time.....

  32. #32
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,803

    Re: Newest Excel Version (For Mac)--> Problems

    I've just checked and 16.47 appears to be the latest non-Insider channel build, so that's not a language thing.

  33. #33
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    but probably not yet available in Dutch format ... I 'll ask my dealer.

  34. #34
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,803

    Re: Newest Excel Version (For Mac)--> Problems

    You said you have 16.47. Also, it will update automatically, you don't need to contact your dealer.

  35. #35
    Registered User
    Join Date
    04-07-2021
    Location
    Belgium
    MS-Off Ver
    MS365
    Posts
    19

    Re: Newest Excel Version (For Mac)--> Problems

    Indeed, 16.47.1 (Dutch version) and missing some basic features I had before :-(

  36. #36
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,873

    Re: Newest Excel Version (For Mac)--> Problems

    Quote Originally Posted by Jan G View Post
    I see, this old-but-never-retiring engineer is talking to a young and smart ICT-girl.
    Well, not really. Iím a teacher of modern foreign languages - 31 years and retiring in July.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Modification to the Newest file in a folder function - Getting a list of 'n' Newest files
    By yoursamrit2000 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-21-2019, 07:22 AM
  2. formala to get totals from list of dates
    By robsin5 in forum Excel General
    Replies: 1
    Last Post: 05-23-2014, 10:18 AM
  3. Arranging Pivot table data from Newest to oldest to Newest does not appear
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-08-2014, 06:53 AM
  4. Ecel woes
    By Larry in forum Excel General
    Replies: 3
    Last Post: 08-22-2006, 12:00 PM
  5. [SOLVED] I have a trial verison of ms office 2003 and its not working
    By wwjd1jrt in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-20-2006, 06:50 PM
  6. [SOLVED] How do i get Ecel on line? why does IE not work?
    By ameron in forum Excel General
    Replies: 0
    Last Post: 01-26-2006, 04:55 PM
  7. re ecel personal sheet
    By WYN in forum Excel General
    Replies: 1
    Last Post: 06-12-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1