My stepmother has found that, ever since upgrading to Windows 10 in June, Excel is putting the space in the wrong place when using the currency or accountancy formats.
As you can see from the attached, Excel is placing a space between the digit signifying the hundred value and the ten value, rather than the thousand value and the hundred value.
So, something that should read $4 470.00 now reads $44 70.00
We have tried varying the currency but it stays the same.
She is working all day with figures and it is a problem as, at a glance, mistakes can be made.
Does anyone know how to change this so the space goes back to the correct place?
I don't know if it makes a difference, but she is based in Latvia.
Thanks
Glayva
Bookmarks