Jump to content

Excel Gods

nextg3n
 Share
Posted

Hello those few of you who are excel gods

 

i could use an idea about excel, when you open: format cells > number, and there is the checkbox for "use 1000 seperator" is there any way that i could make that to be checked by default, since by default it is unchecked and i am yet to find a way to make it checked by default, sinc customs are not favourited here and macros also not welcome for some reason, so i am kinda stumped.

Some EU input to Canadian IT :D 

Link to comment
https://linustechtips.com/topic/1161046-excel-gods/
Share on other sites
Link to post
Share on other sites
Posted

There is a button in excel that will do it, however it does also default to 2 decimal places which may or may not be desired, however right next to it you do also have the 'more decimals' and 'less decimals' buttons. There doesn't seem to be any way to change the check box default.

 

image.png.b1a814ace7095cc968c312e2f878eef2.png

Link to comment
https://linustechtips.com/topic/1161046-excel-gods/#findComment-13343026
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programs, Apps and Websites

×