Adding Text To A Column

[Bob]

Hello,

Last one for today; I promise.

I have a long column of numbers, such as:

456
567
321
784
etc.

The worksheet is formatted as .csv

Is there any easy way to convert this column to:
456 MHz
567 MHz
321 MHz
etc.

And,
would they (still) be interpreted as numbers, or would it now go
a text format (automatically) ?

Thanks for the help,
Bob

 

[Cimjet]

Hi Bob
If you want it to stay numbers, do a custom formating ###" MHz"
or if you want text, you can do it this way assuming you data starts in A1 in
the other cells put =A1&"MHz" and copy down.
HTH
John