SOLVED

excel number

%3CLINGO-SUB%20id%3D%22lingo-sub-1477124%22%20slang%3D%22fr-FR%22%3Eexcel%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477124%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3B%3C%2FP%3E%3CP%3EI'm%20having%20a%20problem%20with%20excel.%20%3CBR%20%2F%3E%20When%20I%20type%20on%20a%20cell%20for%20example%20724768%20it%20shows%20me%20%3CBR%20%2F%3E%20742875%20I've%20tried%20everything%2C%20but%20the%20problem%20persists.%20%3CBR%20%2F%3E%20do%20you%20have%20a%20solution%20%3CBR%20%2F%3E%20see%20capture1--%20when%20I%20type%20%3CBR%20%2F%3E%20result%20-%20result%20thank%20you%20in%20%3CBR%20%2F%3E%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1477124%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478113%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704752%22%20target%3D%22_blank%22%3E%40mameu%3C%2FA%3E%26nbsp%3BIn%20the%202nd%20picture%2C%20the%20number%20in%20the%20formula%20bar%20is%20different%20from%20the%20number%20in%20the%20cell.%20Do%20you%20have%20the%20same%20problem%20in%20every%20new%20blank%20Excel%20file%3F%20what%20if%20you%20try%20to%20enter%20numbers%20using%20the%20Number%20pad%20versus%20the%20Number%20row%20on%20the%20keyboard%3F%20What%20if%20you%20type%20%3D%20first%20then%20enter%20your%20number%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478470%22%20slang%3D%22fr-FR%22%3ERe%3A%20excel%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478470%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3B%20Thank%20you%20for%20your%20feedback.%20always%20the%20same%20problem%20when%20I%20change%20folders.%20When%20I%20type%20724768.%20(Takes%20the%20right%20number)%20I%20reinstalled%20office%2C%20but%20still%20the%20same%20problem.%20I%20don't%20understand%20anything%20anymore.%20see%20screenshot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478524%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478524%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704752%22%20target%3D%22_blank%22%3E%40mameu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20if%20thousand%20separator%20is%20set%20to%202%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20191px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199867i862B40C968D526C3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ein%20Excel%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20601px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199866i235C81E67F678B72%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eor%20in%20OS%20settings.%20For%20Windows%20you%20could%20check%3C%2FP%3E%0A%3CP%3EWin%2BR%20%3CSTRONG%3Econtrol%20internationa%3C%2FSTRONG%3El%20Advance%20setting%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478544%22%20slang%3D%22fr-FR%22%3ERe%3A%20excel%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478544%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%20Sergei%20Baklan%3B%3C%2FP%3E%3CP%3EI%20just%20checked%20%22use%20system%20separator%22%20and%20it%20worked.%20%3CBR%20%2F%3E%20I'm%20relieved%20%3CBR%20%2F%3E%20thank%20you%20so%20much.%20%3CBR%20%2F%3E%20many%20thanks%20again%20%3CBR%20%2F%3E%20Have%20a%20nice%20day%20and%20a%20good%20weekend%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%22mameu_0-1592658124396.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%2F199868i3DFEE2F97D8BBCCF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22mameu_0-1592658124396.png%22%20alt%3D%22mameu_0-1592658124396.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-1478629%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478629%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704752%22%20target%3D%22_blank%22%3E%40mameu%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello ;

I'm having a problem with excel.
when I type on a cell for example 724768 it shows me
742875 I've tried everything, but the problem persists.
do you have a solution
see capture1-> when I type
result -> result
thank you in advance

5 Replies
Highlighted

@mameu In the 2nd picture, the number in the formula bar is different from the number in the cell. Do you have the same problem in every new blank Excel file? what if you try to enter numbers using the Number pad versus the Number row on the keyboard? What if you type = first then enter your number?

Highlighted

Hello ; Thank you for your feedback. always the same problem when I change folders. when I type=724768. (Takes the right number) I reinstalled office, but still the same problem. I don't understand anything anymore. see screenshot

Highlighted
Best Response confirmed by mameu (New Contributor)
Solution

@mameu 

That could be if thousand separator is set to 2

image.png

 

in Excel

image.png

or in OS settings. For Windows you could check

Win+R control international Advance setting

Highlighted

@Sergei Baklan 

Hello, Sergei Baklan;

I just checked "use system separator" and it worked.
I'm relieved
thank you so much.
many thanks again
Have a nice day and a good weekend

 

mameu_0-1592658124396.png

 

Highlighted

@mameu , you are welcome, glad to help