Strange MS Excel problem

Forums › Desktop computing › Strange MS Excel problem

caffynz

317 posts

Ultimate Geek
+1 received by user: 139

ID Verified

Subscriber

#317356 8-Oct-2024 15:13

On several devices, I can input numbers (cells are formatted to display as a percentage) in Excel365 (browser) - and they appear in the right way around.

However, when using one specific device (Windows computer), the numbers appear backwards:

The first two numbers should be 95% and 100%. The third row was typed on another device and appears right.

Other people working on the same document (both desktop and browser) can type in the numbers with no problems.

I've opened another Excel365 document on the problematic device, in browser too, and numbers display there OK.

I looked at text orientation:

None of these match what is happening...

Any ideas what I need to look at next? I.e. why is it happening on this specific device and for this specific file, but other files on this device are OK, and the same file on other devices are OK?

blackjack17

1713 posts

Uber Geek
+1 received by user: 865

#3294697 8-Oct-2024 15:33

Have you tried a different browser on the device that is causing issues?

Electric kiwi signup credit Sharesies credit

Behodar

11095 posts

Uber Geek
+1 received by user: 6074

Trusted

Lifetime subscriber

#3294700 8-Oct-2024 15:39

Are the regional settings correct on the problematic computer? Not set to e.g. somewhere in the Middle East where they write from right to left?

CYaBro

4708 posts

Uber Geek
+1 received by user: 1182

ID Verified

Trusted

#3294703 8-Oct-2024 15:41

Does that PC have Excel installed on it that you can try and open the spreadsheet in and see if it does the same thing?

Opinions are my own and not the views of my employer.

caffynz

317 posts

Ultimate Geek
+1 received by user: 139

ID Verified

Subscriber

#3294704 8-Oct-2024 15:42

blackjack17:

Have you tried a different browser on the device that is causing issues?

Good suggestion, no I hadn't. Just did and it works fine on Chrome.
So - pointing to Firefox to be the culprit? As I've just realised that I use Chrome on other devices (with no problems) but Firefox on the problematic device...

Tested Firefox on other device (where using Chrome the Excel sheet is fine) - same issue is occurring.

So narrowed it down to Firefox browser as the culprit and not the device :)

Any ideas how to fix this?

CYaBro

4708 posts

Uber Geek
+1 received by user: 1182

ID Verified

Trusted

#3294707 8-Oct-2024 15:46

3 workarounds I found:

a) Double-click the cell before you write

b) Press F2 before you write

c) Write into the formula bar

Opinions are my own and not the views of my employer.

caffynz

317 posts

Ultimate Geek
+1 received by user: 139

ID Verified

Subscriber

#3294713 8-Oct-2024 15:57

CYaBro:

Does that PC have Excel installed on it that you can try and open the spreadsheet in and see if it does the same thing?

Yes - and no problem with it. So it seems it's Firefox.

Geekzone support

Support Geekzone with one-off or recurring donations Donate via PressPatron.

caffynz

317 posts

Ultimate Geek
+1 received by user: 139

ID Verified

Subscriber

#3294714 8-Oct-2024 15:57

CYaBro:

3 workarounds I found:

a) Double-click the cell before you write

b) Press F2 before you write

c) Write into the formula bar

These work, thank you!

Still annoying/strange it doesn't work as expected in Firefox browser, but Chrome or desktop Excel is OK.

caffynz

317 posts

Ultimate Geek
+1 received by user: 139

ID Verified

Subscriber

#3294715 8-Oct-2024 15:59

Behodar:

Are the regional settings correct on the problematic computer? Not set to e.g. somewhere in the Middle East where they write from right to left?

Good guess! That is logical, but no - the settings are right on this computer. And as just discovered - it seems it's Firefox and not the device as I originally thought.

CYaBro

4708 posts

Uber Geek
+1 received by user: 1182

ID Verified

Trusted

#3294716 8-Oct-2024 15:59

Mozilla will have to fix it.

Opinions are my own and not the views of my employer.

ANglEAUT

altered-ego
2436 posts

Uber Geek
+1 received by user: 842

Trusted

Lifetime subscriber

#3294923 8-Oct-2024 23:18

caffynz:

... Tested Firefox on other device (where using Chrome the Excel sheet is fine) - same issue is occurring.

So narrowed it down to Firefox browser as the culprit and not the device :)

Any ideas how to fix this?

Did you log into the same Mozilla account on both machines & have sync enabled? Try with no Mozilla account?

Please keep this GZ community vibrant by contributing in a constructive & respectful manner.

caffynz

317 posts

Ultimate Geek
+1 received by user: 139

ID Verified

Subscriber

#3294924 8-Oct-2024 23:20

ANglEAUT:

caffynz:

... Tested Firefox on other device (where using Chrome the Excel sheet is fine) - same issue is occurring.

So narrowed it down to Firefox browser as the culprit and not the device :)

Any ideas how to fix this?

Did you log into the same Mozilla account on both machines & have sync enabled? Try with no Mozilla account?

No, don't have accounts synced on Firefox across devices - still working that out (Recently started using Firefox)