Adding characters
 

Is there a way to add an * be for and after a number I have in a spreadsheet?
I would have a list of numbers such as

56892
56893
56894

I would need to convert them to read

*56892*
*56893*
*56894*

Any help would be appreciated

Hi Amy,

You can use Custom Format if you'd like. This means that it will keep your
values as actual numerics (assuming that they are numerics to start with).
Select all cells in question, hit Ctrl + 1, Number (tab), select Custom on
left and enter this in the textbox on right ..

"*"0"*"

Remember, formatting is only a "mask" and does not influence the cell value
in any way.

--
Regards,
Zack Barresse, aka firefytr

"Amy Johnson" <Amy wrote in message
...
Is there a way to add an * be for and after a number I have in a
spreadsheet?
I would have a list of numbers such as

56892
56893
56894

I would need to convert them to read

*56892*
*56893*
*56894*

Any help would be appreciated

use the "concatenate" function or just type in a new column
=concatenate(*,[your cell #],*)

"Amy Johnson" wrote:

Is there a way to add an * be for and after a number I have in a spreadsheet?
I would have a list of numbers such as

56892
56893
56894

I would need to convert them to read

*56892*
*56893*
*56894*

Any help would be appreciated

Backup your file first, then.....

Assuming your numbers are in column A, put this formula in B1 and copy
down.......

="*"&A1&"*"

Then highlight column B and do Copy PasteSpecial Values........then you
can delete your old column A if you wish.....

Vaya con Dios,
Chuck, CABGx3


"Amy Johnson" <Amy wrote in message
...
Is there a way to add an * be for and after a number I have in a
spreadsheet?
I would have a list of numbers such as

56892
56893
56894

I would need to convert them to read

*56892*
*56893*
*56894*

Any help would be appreciated