View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob[_19_] Bob[_19_] is offline
external usenet poster
 
Posts: 77
Default For Joey2004 et al. From OP: Re Appending Question

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.