A problem with thousand seperator

J

janis

New member
Joined
Jan 15, 2017
Messages
3
Reaction score
0
Points
0
Hello!
I have a very silly problem in my Excel. The thousand seperator has suddenly (I havent changed anything. May be just some update) decided to place the thousand seperator space after every 2 digits (instead of 3 as it should be). Attached is a picture of this.
I am using W10 Home and Excel 2010.
thousands.png
Thanks in advance.
 
Try change settings for separator.
File > Options > Advanced > Editing > Use system separator
or
Clear custom settings if exist (Format cells)
 
navic said:
Try change settings for separator.
File > Options > Advanced > Editing > Use system separator
or
Clear custom settings if exist (Format cells)
Click to expand...

Thanks for the idea, but this doesnt solve the issue. Any other ideas?
 
Perhaps post a sample sheet ( click Go advanced - Manage attachments)
 
Hi!

Thanks. I actually did some deeper research online and this time I found a solution (I had already an idea that it might be it, but previously didnt find where to edit those settings) - it was under the regional settings on computer and under the currency settings (not the number settings as I would expect it to be).
Thanks everyone for help.
 
You must log in or register to reply here.
Back
Top