K Kurios Jun 3, 2004 #1 Can anyone explain how to show negative numbers in brackets on an Excel spreadsheet?
A Andy Brown Jun 3, 2004 #2 Can anyone explain how to show negative numbers in brackets on an Excel spreadsheet? Click to expand... Use a (Format -- Cells -- Number ; category = ) custom format, such as #,##0.00;(-#,##0.00) HTH, Andy
Can anyone explain how to show negative numbers in brackets on an Excel spreadsheet? Click to expand... Use a (Format -- Cells -- Number ; category = ) custom format, such as #,##0.00;(-#,##0.00) HTH, Andy
D Domenic Jun 3, 2004 #3 Kurios said: Can anyone explain how to show negative numbers in brackets on an Excel spreadsheet? Click to expand... Hi, Format > Cells > Number > Numbers, and choose your format. Hope this helps!
Kurios said: Can anyone explain how to show negative numbers in brackets on an Excel spreadsheet? Click to expand... Hi, Format > Cells > Number > Numbers, and choose your format. Hope this helps!
P Peo Sjoblom Jun 3, 2004 #4 Something like 0.00_);(0.00) or General;(General) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom
Something like 0.00_);(0.00) or General;(General) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom