Format Numbers

[praf007]

Is there any way I can add this format permanently in Excel/Format/Custom instead of manually adding open/close brackets

 

[praf007]

I would wager that is already in the list as part of a regular install of Excel. It is in mine, and I can assure everyone that there's no way I added it to the list of custom formats (or any other list).

definitely not in mine. Thanks

 

[praf007]

I don't think that you should need any special workbook or template but try this Windows (not Excel) setting.
First close out of Excel then ..

It may be in a different place for you but for me
Windows settings -> Time & Language -> Region -> then at the top right:

Additional date, time & regional settings: View attachment 120152


Change date, time, or number formats: -> Formats tab -> Additional settings -> Numbers tab -> Negative number format: -> Choose (1.1) -> Apply/OK until you have closed back out

View attachment 120154

Now open Excel again and I believe the wanted option will be there in the Custom number formats area of Excel.

I tried this but didnt work. When i type -ve numbers still comes out as -1.5 without brackets. Will play around with this and see if i can figure it out,. Thanks

 

[Joe4]

After all the comments, did you try the Personal Macro Workbook solution I recommended?
Post 6 shows how you can easily create a Personal Macro Workbook. So then you would just add the VBA code I provided in the earlier post there.
Then, the Personal Macro Workbook should always be open for you on that computer whenever you have Excel open.
So the Macros should always be available to you, without having to do anything special.

 

[still learning]

Hi.
I may be wrong but I'll try.....
I put a similar macro in my personal workbook and put an icon on my Quick Access Toolbar to use it. It is available to all open workbooks.
When I'm dealing with dates, sometimes the result will show a number instead of a date. I then highlight the cell and click on the icon.
I've got a bunch of personal macros ..and some standard ones...on the Toolbar. It saves a few clicks. I don't have to look for it in a tab.
I also have some Quick Access Icons that will only work in the workbook I'm using.

If I'm out of place, I'm sorry...this is the first time I've replied to a question that i didn't post.

Mike

 

[Peter_SSs]

When i type -ve numbers still comes out as -1.5 without brackets.

My suggestion was not about what appears when you type a number into a cell, it was about what appears in the Custom Number Formatting options.