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