Excel number formatting doesn't behave correctly

%3CLINGO-SUB%20id%3D%22lingo-sub-2198655%22%20slang%3D%22en-US%22%3EExcel%20number%20formatting%20doesn't%20behave%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2198655%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20number%20formatting%20on%20the%20labels%20on%20the%20graph%20in%20the%20attached%20file%20shows%20differently%20between%20my%20two%20laptops%20for%20some%20reason.%20The%20numbers%20are%20formatted%20as%20thousands%2C%20with%20space%20as%20thousand%20separator.%20This%20is%20how%20it%20should%20look%20like%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Correct(1).JPG%22%20style%3D%22width%3A%20911px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262360iF65F92F3050A69A4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Correct(1).JPG%22%20alt%3D%22Correct(1).JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I%20open%20the%20excact%20same%20file%20(attached)%20on%20my%20other%20laptop%2C%20this%20is%20how%20the%20graph%20is%20shown%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Not%20correct.PNG%22%20style%3D%22width%3A%20871px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262361i0C9E62F5CA7B8D1F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Not%20correct.PNG%22%20alt%3D%22Not%20correct.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhy..%3F%3F%3F!!%20The%20formatting%20setting%20is%20also%20shown%20differently%20but%20this%20is%20something%20excel%20does%20automatically.%20When%20I%20reopen%20the%20same%20file%20on%20the%20first%20laptop%2C%20the%20graph%20is%20back%20to%20how%20is%20should%20look%20like.%20Any%20ideas%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2198655%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2198706%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20number%20formatting%20doesn't%20behave%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2198706%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F991417%22%20target%3D%22_blank%22%3E%40SvenKL%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%2C%20I%20found%20out..%20Had%20to%20match%20the%20general%20windows%20formatting%20settings%20between%20the%20laptops.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22for.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262364i557CB95AEBBB0A72%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22for.JPG%22%20alt%3D%22for.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

The number formatting on the labels on the graph in the attached file shows differently between my two laptops for some reason. The numbers are formatted as thousands, with space as thousand separator. This is how it should look like:

 

Correct(1).JPG

 

However, when I open the excact same file (attached) on my other laptop, this is how the graph is shown:

 

Not correct.PNG

Why..???!! The formatting setting is also shown differently but this is something excel does automatically. When I reopen the same file on the first laptop, the graph is back to how is should look like. I have tried to input the correct number formatting setting on the second laptop (#.##0.;(#.##0.);"-";) but that gives me error message. Any ideas please?

 

1 Reply

@SvenKL 

Right, I found out.. Had to match the general windows formatting settings between the laptops.

 

for.JPG