Forum Discussion

Copper Contributor

Jun 19, 2020

Solved

excel number

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...

excel

SergeiBaklan
Jun 20, 2020
mameu

That could be if thousand separator is set to 2

in Excel

or in OS settings. For Windows you could check

Win+R control international Advance setting

hynguyen

Iron Contributor

Jun 19, 2020

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?

mameu
Copper Contributor
Jun 20, 2020
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
- SergeiBaklan
  Diamond Contributor
  Jun 20, 2020
  mameu
  
  That could be if thousand separator is set to 2
  
  in Excel
  
  or in OS settings. For Windows you could check
  
  Win+R control international Advance setting
  - mameu
    Copper Contributor
    Jun 20, 2020
    SergeiBaklan
    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