SOLVED

Using Accounting formatting gives different results on two computers

%3CLINGO-SUB%20id%3D%22lingo-sub-1510762%22%20slang%3D%22en-US%22%3EUsing%20Accounting%20formatting%20gives%20different%20results%20on%20two%20computers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1510762%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20computers%2C%20both%20running%20Win10%20and%20the%20same%20version%20of%20Office.%20On%20one%20computer%20the%20format%20'Accounting'%20on%20a%20cell%20is%20correct%20(the%20one%20circled%20in%20red)%2C%20on%20the%20other%20it's%20wrong.%20It%20used%20to%20work%20fine%20in%20old%20versions%20of%20Office%2C%20but%20then%20a%20few%20years%20back%20something%20happened%20and%20now%20I'm%20really%20confused.%20Could%20it%20be%20a%20Windows%20setting%20rather%20than%20something%20in%20Office%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20curious%20thing%2C%20if%20I%20choose%20%24%20instead%20of%20Danish%20kroner%20for%20formatting%2C%20it%20moves%20the%20symbol%20to%20the%20front%20as%20in%20the%20red%20circled%20picture%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECarsten%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1510762%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1522107%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Accounting%20formatting%20gives%20different%20results%20on%20two%20computers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1522107%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F715586%22%20target%3D%22_blank%22%3E%40duksedrengen%3C%2FA%3E%26nbsp%3BYes%2C%20check%20windows%20regional%20settings%20first.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22wsantos_0-1594762286487.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205333i6016BC51FF81F7BB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22wsantos_0-1594762286487.png%22%20alt%3D%22wsantos_0-1594762286487.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1562654%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Accounting%20formatting%20gives%20different%20results%20on%20two%20computers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1562654%22%20slang%3D%22en-US%22%3ESorry%20for%20the%20late%20reply%20(vacation)%2C%20this%20helped%20me%2C%20thanks!%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi

 

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

2 Replies
Highlighted
Best Response confirmed by duksedrengen (New Contributor)
Solution

@duksedrengen Yes, check windows regional settings first. 

wsantos_0-1594762286487.png

 

Highlighted
Sorry for the late reply (vacation), this helped me, thanks!