+ Reply to Thread
Results 1 to 8 of 8

Using Accounting formatting gives different results on two computers

  1. #1
    Registered User
    Join Date
    07-10-2020
    Location
    Denmark
    MS-Off Ver
    Always newest
    Posts
    4

    Using Accounting formatting gives different results on two computers

    Hi

    I tried to post this question in the MS Excel forum days ago, some views, but no answers. Now I'm hoping for better luck here (or that smarter people are here) :-).

    I have two computers, both running Win10 and the same version of Office. On one computer the format 'Accounting' on a cell is correct (the one circled in red), on the other it's wrong. It used to work fine in old versions of Office, but then a few years back something happened and now I'm really confused. Could it be a Windows setting rather than something in Office?

    Another curious thing, if I choose $ instead of Danish kroner for formatting, it moves the symbol to the front as in the red circled picture???

    Carsten
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    12-30-2009
    Location
    US
    MS-Off Ver
    Excel 2010 & 2016
    Posts
    152

    Re: Using Accounting formatting gives different results on two computers

    Hi,

    If you click on the down arrow next to the accounting symbol, then click More Accounting Formats, look at the Decimal places and Symbol options. Are both set the same? It sounds like your default setting in there was changed somehow.

    Capture.JPG
    Last edited by Rick-O-Shay; 07-10-2020 at 01:40 AM.

  3. #3
    Registered User
    Join Date
    07-10-2020
    Location
    Denmark
    MS-Off Ver
    Always newest
    Posts
    4

    Re: Using Accounting formatting gives different results on two computers

    Hi

    Thanks for answering. Yes, I have tried this, nothing is different. I have even found a "kr." (which the computer chooses by default as I'm in Denmark) and I have found one called "kr. Danish", but they both act in the same way?

    Carsten

  4. #4
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    223

    Re: Using Accounting formatting gives different results on two computers

    To see the Excel version: File > Account
    Attached Images Attached Images

  5. #5
    Registered User
    Join Date
    07-10-2020
    Location
    Denmark
    MS-Off Ver
    Always newest
    Posts
    4

    Re: Using Accounting formatting gives different results on two computers

    Hi Joseph

    I actually looked for that in Excel, but couldn't find it, so I grapped it from Outlook, is my Excel 'disconnected' from the rest of Office?

    Attachment 686103

    Carsten

  6. #6
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    223

    Re: Using Accounting formatting gives different results on two computers

    By right, should not. Check the Currency Setting. Go to Control Panel > Date and Time > Change date and time > Change calendar settings > Additional settings > Currency.

  7. #7
    Registered User
    Join Date
    07-10-2020
    Location
    Denmark
    MS-Off Ver
    Always newest
    Posts
    4

    Re: Using Accounting formatting gives different results on two computers

    It works, you are a genius :-). I had a feeling that it might have come from Windows. Thanks a lot :-).
    Carsten

  8. #8
    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
    40,644

    Re: Using Accounting formatting gives different results on two computers

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    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.

+ 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] Excel Macro Runs on Some Computers, Not All- Stalls for computers where it fails to run
    By jamie.harris in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-25-2018, 04:54 PM
  2. Formatting Changes when opening on different computers
    By Andrew13 in forum Excel General
    Replies: 3
    Last Post: 07-29-2015, 09:35 AM
  3. [SOLVED] #DIV/0 Using Accounting formatting
    By lornaerland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2014, 05:27 PM
  4. Excel formatting changes on network computers
    By Lilahbean in forum Excel General
    Replies: 1
    Last Post: 06-11-2013, 07:57 AM
  5. different results on different computers?
    By jcbc in forum Excel General
    Replies: 1
    Last Post: 12-05-2011, 06:59 PM
  6. vertical formatting/pagination across computers
    By garysch37 in forum Excel General
    Replies: 4
    Last Post: 08-21-2009, 04:40 PM
  7. Replies: 0
    Last Post: 01-16-2009, 12:02 PM

Tags for this Thread

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