Can you format numbers in Excel 2007 status bar?

E

elongp

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
 
D

Dianne

Does anyone know if you can format the sum in the status bar? Ou
agency
recently upgraded to Office 2007, and I have a customer asking me. H 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), o 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 sho
commas.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top