For Joey2004 et al. From OP: Re Appending Question

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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
-------------------------------------

Have a very long column of numbers: [....]
I want to add the following text, MHz, to each, e.g.
4MHz
7MHz
9MHz
etc.
Click to expand...

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.
Click to expand...
 
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 ?
Click to expand...

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


Regards
Claus Busch
 
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
 
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.
Click to expand...

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


Regards
Claus Busch
 
Back
Top