Problem with Accounting Formatting Option

Hello,

I've got a problem with trying to format cells with the accounting option.

I want it to show negative numbers in brackets, but it only will show a minus sign in front. I also tried currency to see if it would do it that way as well, but it won't.

Has anyone else had this problem? How do I fix it?

I tried this and it said TRUE.

Please see attached spreadsheet anyway.Book1.xlsx

But since it is a formatting, I'm wondering if it will show up the way I see it anyway. Here is a screenshot as well....Untitled.jpg

I usually click the coma icon and it changes it, but i've tried the $ and selecting accounting from the drop down menu and also by clicking the little arrow thing in the bottom corner of the "number" group and it still has it's own mind...!

When I click the $ sign, the only thing it does different is add a $ to the number!

When I opened it, it stayed with the brackets, but it says custom instead of accounting or currency. It must be a "random" issue that I'm destined to live with!

I'll see what the custom setting is and if I can use it on other books. The thing is, it is every book that I open that does it this way!

Thanks for your help though!!

Thanks,

when I tried the custom format in a new excel spreadsheet, it didn't show up, so it must have just been due to the formatting abilities on yours or something!

martindwilson - there aren't any in a new book - it was only the one he sent me on this post.

TMShucks - looks like yours is doing it the same way mine is. Maybe my machine mysteriously thinks that it is English, but that doesn't make sense because I have it set as Canada/USA.