I need to show numbers with brackets around them rather than with a minus sign - in Excel 2002.
B bradsmih Jul 26, 2004 #1 I need to show numbers with brackets around them rather than with a minus sign - in Excel 2002.
N Norman Harker Jul 26, 2004 #2 Hi bradsmih! You need to change your Regional Settings. Make the change under both Numbers and Currency Tab Apply your way out. You'll find that the () then becomes available as an option.
Hi bradsmih! You need to change your Regional Settings. Make the change under both Numbers and Currency Tab Apply your way out. You'll find that the () then becomes available as an option.
S Soo Cheon Jheong Jul 26, 2004 #3 bradsmih, Try a custom number format like the following: #,##0 ;"["#,##0"]";0 -- Regards, Soo Cheon Jheong _ _ ^¢¯^ --
bradsmih, Try a custom number format like the following: #,##0 ;"["#,##0"]";0 -- Regards, Soo Cheon Jheong _ _ ^¢¯^ --
D Dave Peterson Jul 27, 2004 #4 I think you only need to change the currency tab version. (I was corrected, too!)
