Adding text to numerical data in an entire column

[MLT]

I am trying to add a word to number values in an entire column.

For example, the column has a number in each row such as 15.1 or 149.2, I would like to add the word "million" after each number in the entire column.

Any suggestions?

 

[mezr]

Are the numbers in the column the result of a formula, or are they plugged numbers?

 

[erik.van.geit]

Hi, MLT,
WELCOME to the BOARD!!!!!

You can format your cells like this
(menu Format/Cellproperties: TAB: "number", select custom)
# "million"
It doesn't matter whether the cells are values or formulas.

kind regards,
Erik

 

[DDADUFFER1]

You can concatenate the data with the text. If it's a formula basically use the following:

=+c5&"millions"

 

[Smitty]

Welcome to the Board!

How's: =A1&" Million"

Or if you need to perform calculations you can use Custom Format-->#.# "Million".

Hope that helps,

 

[MLT]

Thank you All, I found =A1&" Million"
to be the formula that I was looking for!