Strange MS Excel problem

Forums › Desktop computing › Strange MS Excel problem

caffynz

275 posts

Ultimate Geek

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

1705 posts

Uber Geek

#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

10510 posts

Uber Geek

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

4589 posts

Uber Geek

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

275 posts

Ultimate Geek

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

4589 posts

Uber Geek

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

275 posts

Ultimate Geek

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.

caffynz

275 posts

Ultimate Geek

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.

Quic Broadband

Move to New Zealand's best fibre broadband service (affiliate link). Free setup code: R587125ERQ6VE. Note that to use Quic Broadband you must be comfortable with configuring your own router.

caffynz

275 posts

Ultimate Geek

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

4589 posts

Uber Geek

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

2327 posts

Uber Geek

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

275 posts

Ultimate Geek

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)