Where is accounting number format in excel 2010

Click Save , and then under Save workbooks , enter the path to the personal templates location in the Default personal templates location box. Enter and format data. Format data. Need more help? Expand your skills. Get new features first. Was this information helpful?

Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions.

Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Remember Me? Results 1 to 11 of Add currency symbol to Quick Accounting Number Format. Register To Reply. Use code tags for VBA. Re: Add currency symbol to Quick Accounting Number Format Well, what you can do is format only one cell with that symbol, then copy it, select the whole "Zar" and "Hi Bob" thing, "paste special But yeah, I understand what you want to do.

But currently I still can't find out how to customize that whole drop down accounting format list Scroll the spreadsheet, using the scroll bars on the right and bottom edges of the spreadsheet, so that you can see the bottom-right cell of your desired range.

Hold "Shift" and click this cell to select the entire range. Click "Accounting" from the list on the left side of the window that appears. Check your Language settings. Also, in he Advanced settings, check Use system separators and make sure Decimal separator is a period and Thousands separator is a comma. Excel allows custom settings for these. Under the sample section you would see samples as to how your numbers, etc.

There is no need to change the home country you can change the grouping option of Digits and Currency by going in windows. I believe there is actually an easier way. In Excel, choose Options — Advanced and look in the first section of Editing options. If these settings are correct for your region, you should not have any problems at all. In the event they are set incorrectly, changing them will fix the problem as Ashish has confirmed. It worked fine for me in , and I showed it out to billions.

They are showing the format simply as , 0. I have my regional settings globally at the OS level set to Indian numbering system i.

This needs to be changed only in a few cells. I have tried some of the suggestions mentioned here and on some other sites, but of no help. Appreciate if somebody could suggest a way to handle this.

On the specific cells where you need that format, set the Cell Format to " , , ,. I tried all of the above, only the advice from Kerresa worked. By changing the Format Tab. The "right click, then Format cells" did not work. The Digit Grouping was already on the desired option with the use system separator.

Thank you for the quick response. I tried your suggestion but does not seem to be working. Looks like my OS and Excel global settings are over riding the local settings. The format you show in your most recent post appears to suppress the comma between millions and billions.

That is, you will get results like: "1,,", ",,", and ",,".