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

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
"Bob" <(E-Mail Removed)> wrote in message
news:id5q2r$1un$(E-Mail Removed)...
> 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