If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can you format numbers in Excel 2007 status bar?
Does anyone know if you can format the sum in the status bar? Our agency
recently upgraded to Office 2007, and I have a customer asking me. He has large sums, in the millions, and was wishing for the comma thousands separator. I could not find any posts via google, Excel Help (pretty useless), or on the forums. Thanks! E Powell Austin, TX |
#2
|
|||
|
|||
Can you format numbers in Excel 2007 status bar?
I don not believe you can change format on the Status Bar.
You can add this event code to Thisworkbook. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _ ByVal Target As Range) Dim s As String Dim wfn As WorksheetFunction Set wfn = Application.WorksheetFunction On Error GoTo errH: If wfn.Count(Target) 2 Then s = "" Else s = "Sum=" & Format(wfn.Sum(Target), "#,##0.00") End If errH: Application.StatusBar = s End Sub Gord Dibben MS Excel MVP On Thu, 15 Apr 2010 12:33:02 -0700, elongp wrote: Does anyone know if you can format the sum in the status bar? Our agency recently upgraded to Office 2007, and I have a customer asking me. He has large sums, in the millions, and was wishing for the comma thousands separator. I could not find any posts via google, Excel Help (pretty useless), or on the forums. Thanks! E Powell Austin, TX |
#3
|
|||
|
|||
Can you format numbers in Excel 2007 status bar?
Too simple Dianne.
I have never noticed thatg Gord On Thu, 15 Apr 2010 19:47:35 +0000, Dianne wrote: elongp;700459 Wrote: Does anyone know if you can format the sum in the status bar? Our agency recently upgraded to Office 2007, and I have a customer asking me. He has large sums, in the millions, and was wishing for the comma thousands separator. I could not find any posts via google, Excel Help (pretty useless), or on the forums. Thanks! E Powell Austin, TX The cells in your worksheet should be number format with the comma sep. When you highlight the cells, the sum in status bar should show commas. |
Thread Tools | |
Display Modes | |
|
|