Default format for decimal numbers

Good evening,

Strange request, well if I understood correctly, if this is what you are looking for, you need to change the regional settings

Control Panel/Region and Language/Formats tab/Additional settings/set Number of decimals to 0

if this is not what you are looking for, follow the same path and reprogram the number of decimals to 2
--
A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Hello Mike-31.

Thank you very much for taking the time to answer my strange question! Unfortunately, I wasn't able to achieve the expected result by following your instructions.
In the control panel, I selected `Regional and Language Options` and in the window that opened, I clicked on `Customize`. In the new window, I replaced the 2 with 0 in the second line `Number of decimals`. In the fourth line, `Digit grouping`, I left what was there, which is 123 456 789.
I then selected a range containing the numbers 3506 and 3 506 and 3506.1, I chose 'Cell Format' and clicked on `Number`. In the window, it then shows (as before) Example 3506.00 and Number of decimals 2, and `Use 1000 separator` is not checked. By clicking OK, I get all the selected numbers in the format 5608.00. To get them in the format 5 608, I have to click two more times before clicking OK.
Since I very often need the format with 0 decimals and with a thousands separator, I would like to see when I click on the `Number` format: `Example: 5 608` and `Number of decimals: 0` and `Thousands separator` checked (as it appears in the control panel window). I wonder if it's possible.
I would like to have this result "by default" if that is possible.
If you could spare me a few more lines..... Thanks in advance.

Hello to both of you.

I looked into it as well, and it doesn't seem possible to get this default format.
Tobakisa, you will need to select the entire new sheet every time you create one by pressing [ctrl+A], then choose Format/Number/Number/ and set 0 decimal places and a thousands separator. That's pretty much what you're doing ...

If you could let us know what work you need this specific format for, maybe we could suggest a trick ...

--
Retirement is great! Especially in the Caribbean ... :-)
? Raymond (INSA, AFPA, CF/R)?

Hello Raymond,
Thank you very much for the information and for your suggestion. If there is anyone who knows if it's possible to obtain my default format, he or she will probably let me know. But it's not a big deal that I have to keep clicking two more times. And if I think about it... choosing my simple format before starting a new sheet, as you suggested, will already save me a lot of clicks!
I'm also glad that by asking a first question in "How it works," I immediately found helpful people who are doing what they can to assist me. I hope to often discover 'how it works' thanks to your help. Thank you!

If you take a look at the discussions on CCM, particularly in the Office forum, you will notice that there are two categories of askers:
- Those who are pretentious and arrogant, who ask questions while believing they already know everything, and who usually show aggression and bad manners. They are put in their place, reminded of the rules, and invited to respect the CCM Charter.
- And those who are courteous and polite, who provide the necessary details when asked, and who are satisfied to have received help, or at least a listening ear.
These are welcome and can be assured of receiving the same warm welcome for their future requests.
I encourage you to continue to stay in this second category...

Best regards.

--
Retirement is nice! Especially in the Caribbean... :-)
? Raymond (INSA, AFPA, CF/R)?

Hello everyone,

I believe there has been a deviation from the original question.
I understand that he often uses the Integer+Thousand Separator format, but not necessarily that all the cells in all created workbooks have this format.

A small macro that does this:

Sub FormatInteger() Selection.NumberFormat = "#,##0" End Sub

to be placed in a standard module.
Select the relevant range and run the macro.
In the attached example, I've assigned the keyboard shortcut Ctrl+e.

You can also customize your toolbar to add an icon that will launch it.
And also save the file in the add-in format (*.xla or *.xlam depending on the version of Excel). Once activated, it will be loaded automatically when Excel starts, so it will be available at all times without further action, and the workbook will remain hidden.
https://www.cjoint.com/?DFkkkKnsSf3

In 2010 you can also use the 'Home / Number' icons; with 3 quick clicks you can achieve your format on your selection.

Eric
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it will work. (the Shadoks)
In addition to the thank you (yes, it is done!!!), remember to mark it as resolved. Thank you.