what i do is copy a blank cell. then select the cells formatted as text, right
click, select pastespecial then add. it will change them to numbers.



--


Gary


"Madiya" wrote in message
...
On Sep 26, 11:44 am, "Nigel" wrote:
In the customize status bar prior to xl2007 is limited unless you run some
of your own code. Xl2007 offers a lot more options.

--

Regards,
Nigel


"Madiya" wrote in message

...



I have to do lot ofselection and check sum and count.
Status bar in excel shows sum and count one at a time.
Is there a way, status bar shows sum and count both?

Regards,
Madiya- Hide quoted text -

- Show quoted text -

Thanks to both of you for help.
Boris,
However, I have a small problem.
The sheet I am working on is a dump from the SAP.
Due to this most of the cells are formatted as text.
The code you posted workes fine in general but if I select those text
formatted
cells, it shows count also = 0 instead of showing the count of cells
having anything like text.

Any fix for that?

Thanks,
Madiya