I'm trying to get a whole bunch of numbers in the format (-0.007). I'm trying to make it so it automatically adds the parentheses (no problem with custom cell formatting) however, no matter what i try, the negative sign (for numbers that are negative) will always appear outside of the parentheses. Is there any way to fix this? Instead of looking like this: (-0.007), it looks like this -(0.007) when i type in the number -0.007. Any help is much appreciated.
I'm running Excel 2003 SP2.
Thanks for any help you can give...
2007-02-27 03:54:32 · 5 answers · asked by localgod208 3 in Computers & Internet ➔ Software
0.00;-(#.00);- doesn't seem to solve the problem, as the negative sign still appears outside of the parentheses.
2007-02-27 04:04:38 · update #1
Go to cell format > Select Numbers > Select the format that you want.
2007-02-27 03:58:49 · answer #1 · answered by Anonymous · 0⤊ 2⤋
Set up a new location where you can put the following formula to match the data entry area. (I used A1 as example; you will have to start with whatever cell area you are using)
=IF(A1<0,"-"&"("&A1*-1&")",A1)
If all you want is a special appearance it will work fine.
The downside of this is the cells are now text and can't be treated as a number. The formula should work with plus or minus numbers.
2007-02-27 05:20:22 · answer #2 · answered by Don R 5 · 1⤊ 0⤋
Well, i dont know. But i suggest you to visit this site www.ExcelGoodies.Com , there would be some excel consultants online on the chat. may be u can chat with them and get ur doubts clarified.
2007-02-27 06:24:02 · answer #3 · answered by sam e 2 · 0⤊ 2⤋
Copy this and paste in custom formatting
0.00;-(#.00);-
2007-02-27 04:00:54 · answer #4 · answered by unnga 6 · 1⤊ 1⤋
0.00;(-#.00)
Just a minor change ;-)
good luck
M.
2007-02-27 04:28:29 · answer #5 · answered by Martin G. 4 · 1⤊ 0⤋