Dec 15, 2004 #1 fb599 Electrical Oct 25, 2001 32 0 0 GB Can anyone tell me how to format a number to have brackets automatically in an Excel spreadsheet when the numbers are negative values please. This is a financial application however ! Thanks
Can anyone tell me how to format a number to have brackets automatically in an Excel spreadsheet when the numbers are negative values please. This is a financial application however ! Thanks
Dec 15, 2004 #2 IRstuff Aerospace Jun 3, 2002 44,348 4 38 US You should be able to specify that in the custom number formats, just like the ones that make negative numbers red. TTFN Upvote 0 Downvote
You should be able to specify that in the custom number formats, just like the ones that make negative numbers red. TTFN
Dec 15, 2004 #3 jproj Chemical Oct 9, 2001 324 0 0 US Using custom format, #,###.00;(#,###.00) produces the following: 500.2945 ----> 500.29 -52300.153 ----> (52,300.15) You can manipulate the format by changing the number of #'s and 0's. The important part is #;(#). Good luck! jproj Upvote 0 Downvote
Using custom format, #,###.00;(#,###.00) produces the following: 500.2945 ----> 500.29 -52300.153 ----> (52,300.15) You can manipulate the format by changing the number of #'s and 0's. The important part is #;(#). Good luck! jproj
Dec 15, 2004 #4 JEB66 Mechanical Jan 9, 2003 105 0 0 US Format cell, then click on number and then on how you want then negitive numbers to show up( in the lower left of the format pop up) Upvote 0 Downvote
Format cell, then click on number and then on how you want then negitive numbers to show up( in the lower left of the format pop up)