Hello,

Thanks so much for help; really appreciate it.

Not sure how to implement what you are suggesting:

Regarding the Custom Format suggestion: O"MHz"

What is the O ? Is this a letter or number ?
What do I put for it; could you give me an example using my data, please ?

Hate to appear dumber with this than I am, but will blame it on
"old-age" now.

Much thanks,
Bob
-------------------------------------

On 2/28/2013 7:38 PM, joeu2004 wrote: "Bob" wrote:
Have a very long column of numbers:
[....]
I want to add the following text, MHz, to each, e.g.
4MHz
7MHz
9MHz
etc.

Instead of making the cell text per se, I would suggest that you simply
use a Custom format, e.g. 0"MHz" .

Thus, the cell retains in numeric value, but MHz appears in the
displayed value.

Select the cells to change their format. Or use the Format Painter tool.

Hi Bob,

Am Fri, 01 Mar 2013 12:31:41 -0500 schrieb Bob:

What is the O ? Is this a letter or number ?
What do I put for it; could you give me an example using my data, please ?

if you only have integers, then it is a zero
If you have decimals, then try 0,00 "MHz"


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Hi Claus,

Much thanks.

Might I ask one more, please:

In one of my columns, Column D, I have, e.g.,
a
b
a
a
f
g
a
w

I want to Delete any and all rows that have an "a" in Column D.

I thought I could use the Filter Command, but this doesn't seem appropriate.

What's the best way, please ?

Thanks again,
Bob
-----------------------------------------------------------------------------------


On 3/1/2013 12:39 PM, Claus Busch wrote:
Hi Bob,

Am Fri, 01 Mar 2013 12:31:41 -0500 schrieb Bob:

What is the O ? Is this a letter or number ?
What do I put for it; could you give me an example using my data, please ?

if you only have integers, then it is a zero
If you have decimals, then try 0,00 "MHz"


Regards
Claus Busch

Hi Bob,

Am Fri, 01 Mar 2013 13:04:12 -0500 schrieb Bob:

In one of my columns, Column D, I have, e.g.,
a
b
a
a
f
g
a
w

I want to Delete any and all rows that have an "a" in Column D.

to filter for "a" is the best way. Select the visible rows and delete
them.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2